topic Range Count issue in QlikView

Range Count issue

Mon, 07 Dec 2015 16:04:40 GMT

I'm trying to range item with a conditional count in QlikSense.

I've made in the load script a WeigerFlag as condition

So in the first column is the range part I'm trying. The second column is the normal count. It seems it just jumped a week lower instead of adding it to the previous amount.

What do I do wrong

Regards,

Liselotte

Re: Range Count issue

Gysbert_Wassenaar — Mon, 07 Dec 2015 18:41:14 GMT

You didn't add any parameters to the Above function so it only gets the value of the previous row. If you want a running total you need something like rangesum(above(count(...xxx...),0,rowno()))

Re: Range Count issue

Tue, 08 Dec 2015 08:07:21 GMT

Hi,

I've tried but it still doesn't work 😞

The calculation is

rangesum(above (Count(Distinct{$ < WeigerFlag= {'1'} >} [WerkopdrachtID])), 0, RowNo())

Is it due to the count with condition?

Regards,

Liselotte