Range Count issue

[#1]

Hi

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

[Gysbert_Wassenaar · Accepted solution]

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()))

[#3]

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