topic Re: count users in QlikView

count users

Fri, 28 Mar 2014 13:22:58 GMT

I want to count users per monthyear and I am using an expression in a straight table to do so.

The expression is:

=Count(DISTINCT userID({<monthyear = {'January 2013'}>} userID))

Obviously there is something wrong with this expression, can someone help me correct it?

Thanks!

Nicole-Smith — Fri, 28 Mar 2014 13:24:43 GMT

=Count({<monthyear = {'January 2013'}>} distinct userID)

Aurelien_Martinez — Fri, 28 Mar 2014 13:25:02 GMT

Hi,

Try this :

=Count(DISTINCT {<monthyear = {'January 2013'}>} userID)

Aurélien

MK_QSL — Fri, 28 Mar 2014 13:30:02 GMT

Create a straight table

Dimension = MonthYear

Expression

= Count(Distinct userID)

Fri, 28 Mar 2014 13:30:12 GMT

thanks