Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with set expression

Looking to count the distinct users where month is less than or equaly to april 2014. When I apply the formula it returns a 0. Can anyone suggest what I am doing wrong here?

Count(Distinct{<Month={"<={'Apr'}"}>}Event.User)

3 Replies
venkatg6759
Creator III
Creator III

Try to use Num# function before month and try

Not applicable
Author

can you give an example please? syntax is everything

its_anandrjs
Champion III
Champion III

Try one of this ways and add a NumMonth field in the model like and then use that field in your expression see the expression below.

Load

Num(Month(DateField)) as NumMonth

From Location;


=Count(Distinct{<NumMonth = { "<=$(=Num(Month(AddMonths(Today(),-2))))"  }>}Event.User)