Cumulative By MonthYear , Column Level

ch_riadh — Tue, 03 Jan 2017 08:22:17 GMT

Hi,

I tried to create a Cumulative sum By Month, with expression :

RangeSum(Above(TOTAL Sum({<Pipeline) , 0, RowNo(TOTAL)))

it works fine when the MonthYear Dimension Row Dimension like in the straight Table,

but when i move the MonthYear Dimension up, Column Dimension like in Pivot table or use same expression in chat it goes wrong, Because it works only with row.

Please check the excel attached so you can understand more.

Thanks for help.

Re: Cumulative By MonthYear , Column Level

pathiqvd — Tue, 03 Jan 2017 09:06:02 GMT

Hi Riad,

Try this, May be you will get

=rangesum(Before(sum(pipeline),0,ColumnNo()))

Regards,

topic Cumulative By MonthYear , Column Level in QlikView

Cumulative By MonthYear , Column Level

Re: Cumulative By MonthYear , Column Level