Expression (Syntax Modification)

[hkg_qlik]

Hi,

=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))

Thanks,

H

[#2 · Accepted solution]

Not sure to understand

=sum(aggr(count(distinct if(Month = vCurrentMonth and year = vCurrentYear,[Person ID])),Date))           

[hkg_qlik]

Thanks Eva.