Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hkg_qlik
Contributor II

Expression (Syntax Modification)

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

1 Solution

Accepted Solutions
Not applicable

Re: Expression (Syntax Modification)

Not sure to understand

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

2 Replies
Not applicable

Re: Expression (Syntax Modification)

Not sure to understand

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

hkg_qlik
Contributor II

Re: Expression (Syntax Modification)

Thanks Eva.

Community Browser