topic Re: Cumulative sum expression is working erracticly in QlikView

Cumulative sum expression is working erracticly

aniruddhyadutta — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am facing some issues while calculating the cumulative sum

when I am using this expression my chart is showing correct data

RangeSum(Above(Sum({$< Hour_15={'$(v2)','$(v3)','$(v4)'}>} ALERT_Count),0,RowNo()))

but this same expression if I use with an if else condtion is not behaviung correctly

If (SELECTOR = 'CUM',RangeSum(above(sum({$< Hour_15={'$(v2)','$(v3)','$(v4)'}>} ALERT_Count),0,RowNo())), sum({<Hour_15= {'$(v2)','$(v3)','$(v4)'}>}ALERT_Count))

here you can see the cumulative has been done from 11:00 and 11:15.

I am using the if -else to use the expression in a toggle expression.

Re: Cumulative sum expression is working erracticly

marcus_sommer — Mon, 24 Oct 2016 18:44:54 GMT

Try it with:

RangeSum(Above(Sum({$< Hour_15={'$(v2)','$(v3)','$(v4)'}, SELECTOR = {'CUM'}>} ALERT_Count),0,RowNo()))

- Marcus

Re: Cumulative sum expression is working erracticly

aniruddhyadutta — Tue, 25 Oct 2016 10:47:51 GMT

Hi Marcus,

it worked for 'CUM'

but this is I believe has become hard coded for only "Cum'.Is there any way to make this expression dynamic i.e if we select 'Non-Cum' as a selector value to show in the same expression?

Thanks,

Aniruddhya

Re: Cumulative sum expression is working erracticly

marcus_sommer — Tue, 25 Oct 2016 17:06:35 GMT

Try it with:

RangeSum(Above(Sum({$< Hour_15={'$(v2)','$(v3)','$(v4)'}, SELECTOR = p(SELECTOR)}>} ALERT_Count),0,RowNo()))

- Marcus