topic Re: Cumulative sum over a dimension in QlikView

Cumulative sum over a dimension

Fri, 04 Jul 2014 14:16:01 GMT

I have a pivot table with a dimension [Year]. The expression in the pivot table is the sum of revenues: sum(Revenue). Instead of having the sum of revenues for 2010 to 2014, I would like to have the cumulative sum over years starting in 2010.

I cannot use the Accumulate option because I am using the Full Browser version and there seems to be no such option in the Full Browser version.

Thanks in advance

Re: Cumulative sum over a dimension

Gysbert_Wassenaar — Fri, 04 Jul 2014 14:19:12 GMT

The accumulation option will work in webview too. But perhaps it's easier to enable the option in normal view. If you don't want to use the accumulation option then have a look at this document for some alternatives: Calculating rolling n-period totals, averages or other aggregations

Re: Cumulative sum over a dimension

Fri, 04 Jul 2014 14:22:04 GMT

Thanks for your reply.

Do you know where I can find the option in the Full Browaser mode ?

Thanks for the link, will look at it

Re: Cumulative sum over a dimension

Gysbert_Wassenaar — Fri, 04 Jul 2014 14:32:43 GMT

Under Expressions select an expression and click the More button. You'll find an Accumulate Expression option. Click on the sprocket wheels to change the properties for the accumulation option.

Re: Cumulative sum over a dimension

Fri, 04 Jul 2014 14:50:01 GMT

Thanks for your quick answer.

Maybe we do not talk about the same kind of visualization, or maybe it is because i have limited edition rights... In the Full Browser version i have, there seems to be no such option for accumulate... Below is a screenshot

would you have a further idea where the option could be in this Full Browser version ? there are a lot of options, it is strange that accumulate option is not available as well...

Re: Cumulative sum over a dimension

Gysbert_Wassenaar — Fri, 04 Jul 2014 14:53:30 GMT

Ah, I see now you're using a pivot table. Pivot tables don't have an accumulation option at all, not in webview, not in normal view.

Re: Cumulative sum over a dimension

Fri, 04 Jul 2014 14:55:18 GMT

Thanks for this. Also are alternative options (with an expression) possible in pivot table ?

Re: Cumulative sum over a dimension

Gysbert_Wassenaar — Fri, 04 Jul 2014 14:55:54 GMT

See the document I referred to earlier.