topic Re: Expression (Syntax Modification) in QlikView

Expression (Syntax Modification)

hkg_qlik — Mon, 18 Jun 2012 15:48:13 GMT

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,

Mon, 18 Jun 2012 16:03:50 GMT

Not sure to understand

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

hkg_qlik — Mon, 18 Jun 2012 16:52:02 GMT

Thanks Eva.