topic Re: How to do cumulative sum in qlikview in QlikView

How to do cumulative sum in qlikview

Tue, 31 Mar 2015 14:23:06 GMT

Hi Team,

Please help me in doing the Cumulative sum.I have 5 years of data in the input file but my report has to show last 2 years data.

For each month I want the sum from beginning to current month .For your reference attaching the sample data .

Input file

===========

year	month	Value
2014	Nov	5
2014	Dec	10
2015	Jan	15
2015	Feb	20
2015	Mar	25

Output

==============

Re: How to do cumulative sum in qlikview

Tue, 31 Mar 2015 14:24:39 GMT

Sorry output i want in this manner

Thanks in Advance

Re: How to do cumulative sum in qlikview

avinashelite — Tue, 31 Mar 2015 14:35:19 GMT

check this example app

Re: How to do cumulative sum in qlikview

MK_QSL — Tue, 31 Mar 2015 14:38:58 GMT

use below script

Test:

Load

year,

Date#(month,'MMM') as month,

Value

Inline

[

year, month, Value

2014, Nov, 5

2014, Dec, 10

2015, Jan, 15

2015, Feb, 20

2015, Mar, 25

];

Final:

Load

RangeSum(Peek('TotalValue'),Value) as TotalValue

Resident Test

Order by year, month;

Drop Table Test;

now create a Pivot Chart

Dimension (Both Calculated Dimensions)

=ValueList('Cumulative','Value')

=IF(year = 2015, month)

Expression

IF(ValueList('Cumulative','Value') = 'Cumulative', SUM(TotalValue),SUM(Value))

Re: How to do cumulative sum in qlikview

MK_QSL — Tue, 31 Mar 2015 15:29:11 GMT

If you have got your answer, kindly close the thread by selecting appropriate answer so that others can also use it..