topic Re: getting cumulative values in graph in QlikView

getting cumulative values in graph

Fri, 13 Sep 2013 16:20:35 GMT

hi is there any way to add up on week by week values for example

330 = 8/2

330+450 =8/9

330+450+600 =8/16

330+450+600+570 = 8/23

in a line chart

Re: getting cumulative values in graph

Gysbert_Wassenaar — Fri, 13 Sep 2013 16:26:28 GMT

Yes. The easiest way is to enable the option Full Accumulation for the expression. In a line chart you'd use Week as dimension, sum(Value) as expression and enable full accumulation for the expression.

Re: getting cumulative values in graph

Fri, 13 Sep 2013 16:29:04 GMT

Apache,

You should be able to use the "Accumulation" setting on the Expressions tab. Highlight the the expression you wish to accumulate and select Full Accumulation.

Re: getting cumulative values in graph

Tue, 05 Nov 2013 18:24:33 GMT

Hi,

With full accumulation, if you want to add a text color, what will be the code used?

If you use IF(SUM(SALES)>0, Green(),Red()) , it does not work because it retrieves the Non-Accumulated value.

If you use IF(Column(2)>0,Green(), Red()) , it still does not work.

How to account for the Accumulation for Text Color Coding when Visual Cues does not exists. (ie for Combo Charts)

Thanks