Discussion Board for collaboration related to Creating Analytics for QlikView.
=sum(aggr(count(distinct [Person ID]),Date)) - Counts the Person ID.
Req: I want to create a Text object which shows only the count for Current Year and Month. ( vCurrentMonth & vCurrentYear - Created)
How to accomodate the above requirement in existing syntax for count which is =sum(aggr(count(distinct [Person ID]),Date))
Go to Solution.
Not sure to understand
=sum(aggr(count(distinct if(Month = vCurrentMonth and year = vCurrentYear,[Person ID])),Date))