Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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()))
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()))
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