How to show count of distinct id irrespective of year and month selection ?

[suvechha_b]

Hi All ,

I want to count the user id irrespective of year and month

=Count(DISTINCT id)

THanks,

[sunny_talwar]

May be this

Count(DISTINCT {<Month, Year>} id)

[suvechha_b]

Hi Sunny ,

The expression not working correctly ,

Count(DISTINCT {<Month, Year>} id)

Please suggest.

Thanks,

Re: How to show count of distinct id irrespective of year and month selection ?

[ali_hijazi]

What Sunny shared should work, unless your column names are different!!

Qlik is case sensitive

or maybe you need to add '=' sign if you are displaying the count in a text object?

[tresesco]

Are you using this expression in a chart? Are Month and Year are dimensions there? If so, you might have to use identifier TOTAL

[suvechha_b]

Hi Tresesco ,

I am using this expression in a chart . No the 'Month' and 'Year' are not present in the chart .

Please see the image attached.

[tresesco]

In that case Sunny's expression should work. Could you provide sample app and describe the expected output?

[sunny_talwar]

What isn't working in the attached image? Can you elaborate a little more? What did you expect to see when Year and Month are selected?

[qlik4asif]

=Count( DISTINCT {<Month,Year>}Total id)