topic Re: problems with count in QlikView

problems with count

Mon, 06 Oct 2014 11:37:43 GMT

Hi There,

I am having issues in getting the count statement

My expression is that count ({<NYEAR=mainyear>} distinct num) . When a filter is applied it work else it show 0 .

How can this be corrected. Please help .

regards

varghese

Re: problems with count

jonathandienst — Mon, 06 Oct 2014 11:49:03 GMT

If mainyear is another field and you are trying to do row-by-row calculations, you cannot use a set expression, as the expression is evaluated once for the table/chart and not on every row.

You can do sum(if(NYEAR = mainyear, DISTINCT num)),

You can create a flag field in the load script:

LOAD ....

NYEAR,

mainyear,

If(NYEAR = mainyear, 1, 0) As YFlag,

....

and then use the flag in your expression:

Sum({<YFlag = {1}>} Distinct num)

HTH

Jonathan

Re: problems with count

Mon, 06 Oct 2014 15:59:52 GMT

Dear Jonathan

Thanks , It worked.

regards

Varghese

Re: problems with count

Mon, 06 Oct 2014 17:55:59 GMT

count (distinct {<NYEAR={'mainyear'}>} num)