Solved: Qlik sense how to look for a first time appeared v… – Qlik Community

Hi, just to conclude here, following are the expressoins for YTD and LYTD new materials occurency counts in KPI settings.

=’YTD ‘ & num(Count(DISTINCT {<Year,Quarter,Month,Week,Date={“$(=’>=’&Date(AddYears(YearStart(Max(Date),0,7),0), ‘YYYY/MM/DD’) & ‘<=’&Date(AddYears(Max(Date),0), ‘YYYY/MM/DD’))”}>}
(If(Aggr(NODISTINCT Min(Date), Material)=Date, Material))),’#,##0.00K;($#,##0.00)’)

&chr(13)&’ LYTD ‘ &
num(Count(DISTINCT{<Year,Quarter,Month,Week,Date={“$(=’>=’&Date(AddYears(YearStart(Max(Date),0,7),-1), ‘YYYY/MM/DD’)
& ‘<=’&Date(AddYears(Max(Date),-1), ‘YYYY/MM/DD’))”}>}
(If(Aggr(NODISTINCT Min(Date), Material)=Date, Material)))/1000,’#,##0.00K;($#,##0.00)’)