topic Re: Cumulative By MonthYear , Column Level in QlikView

Cumulative By MonthYear , Column Level

ch_riadh — Thu, 22 Dec 2016 07:10:12 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

adamdavi3s — Thu, 22 Dec 2016 07:21:51 GMT

Try replacing Above with Before instead

Re: Cumulative By MonthYear , Column Level

ch_riadh — Thu, 22 Dec 2016 07:33:35 GMT

No, Same Issue.

Re: Cumulative By MonthYear , Column Level

adamdavi3s — Thu, 22 Dec 2016 07:35:55 GMT

Hmmm weird it should work, can you share your expression as the one above looks incomplete (missing set analysis brackets)

Missing Manual - Before() and After()

Re: Cumulative By MonthYear , Column Level

ch_riadh — Thu, 22 Dec 2016 07:49:05 GMT

RangeSum(Above(TOTAL Sum(Pipeline) , 0, RowNo(TOTAL))) this is work fine when the monthyear dimension is a row dimension,

but i move it up to Column dimension goes wrong.

I tried 'before' , 'after' . not working

If you can do it for me i ll be thankful.

you can use the data in the excel u shared.

Thanks for help.

Re: Cumulative By MonthYear , Column Level

tresB — Thu, 22 Dec 2016 09:14:55 GMT

Before() should work unless you are using multiple expressions in the chart and wishing to add up all of them. Could you post a sample qvw that demonstrates the issue?

Re: Cumulative By MonthYear , Column Level

ch_riadh — Thu, 22 Dec 2016 10:12:57 GMT

I share with you the excel, can you try to do it ?

Thanks

Re: Cumulative By MonthYear , Column Level

ch_riadh — Tue, 03 Jan 2017 08:20:11 GMT

hello, you did it ?