topic Re: Help with set expression in QlikView

Help with set expression

Mon, 23 Jun 2014 20:42:47 GMT

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)

Re: Help with set expression

venkatg6759 — Mon, 23 Jun 2014 20:53:48 GMT

Try to use Num# function before month and try

Re: Help with set expression

Mon, 23 Jun 2014 20:59:48 GMT

can you give an example please? syntax is everything

Re: Help with set expression

its_anandrjs — Mon, 23 Jun 2014 21:10:36 GMT

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)