topic Re: Expression for Count Distinct All Prior Periods in QlikView

Expression for Count Distinct All Prior Periods

Sat, 21 Jun 2014 04:24:53 GMT

count(distinct {$<Month={"<={'Apr'}"}>} Event)

what would the proper syntax be to count all distinct events before April. The expression above is returning 0.

Re: Expression for Count Distinct All Prior Periods

Sokkorn — Sat, 21 Jun 2014 04:38:48 GMT

Hi Jonh,

You may try

count({$<Month={"<={'Apr'}"}>} distinct Event)

Regards,

Sokkorn

Re: Expression for Count Distinct All Prior Periods

MK_QSL — Sat, 21 Jun 2014 08:37:08 GMT

Count(Distinct {<Month = {"<={'April'}"}>}Event)

If you want to consider for only current year, use as below

Count(Distinct {<Month = {"<={'April'}"}, Year = {'2014'}>}Event)

Re: Expression for Count Distinct All Prior Periods

Mon, 23 Jun 2014 16:10:31 GMT

Tried all of the expressions listed above and I get a 0 result back, which I know is not the case. Could there be something erroneous with specifying less than 'Apr'?

Re: Expression for Count Distinct All Prior Periods

vgutkovsky — Mon, 23 Jun 2014 21:38:40 GMT

You can't compare "Apr" as a numeric value. Try this: count({<Month={"<=4"}>} distinct Event)

Regards,

Vlad