How can we show the cumulative total of total sales using line chart in Qlikview?

qlikview

#1

Hi,

I want to show the cumulative total of sales over months using a line chart. Is there any option available or should we create a variable in edit script for it.

Thanks,
Mukesh


#2

@mukesh,

You can use accumulation method in expression tab to show the cumulative total of a particular expression. Below you can see option for accumulation. Here we have three option under accumulation tab:

  1. No Accumulation is just your normal expression. The appropriate aggregated results(sum or count for example) against the respective dimensions
  2. Full Accumulation is also called running total. It will take into consideration the current result + all the prior results. For example the result of fifth row(dimension) would be 1st+ 2nd + 3rd + 4th + 5th row results.
  3. Accumulate: Step back is like a partial running total. Instead of taking all the previous records it only takes based on whats mentioned in the step back. Lets say step back is 3, then the result of the 5th record would be 3rd+4th+5th

Regards,
Satish