Cumulative sum in qliksense Bar Chart with two dimensions

[ramkrishna86]

Hello Guys,

Could you please help me how to calculate cumulative sum in qlik sense bar chart with 2 Dimensions.

This expression only works for 1 dimension:

rangesum( above( sum([Expression1]),0,rowno()))

I have data like below table where MonthName and Industry are dimensions in chart and Amount is Measure.

MonthName	Industry	Amount	Year
Jan	AA	100	2015
Feb	BB	200	2015
Mar	CC	300	2015
Apr	DD	400	2015
May	EE	500	2015
Jun	FF	600	2015
Jul	GG	700	2015
Aug	HH	800	2015
Sep	II	900	2015
Oct	JJ	1000	2015
Nov	KK	1100	2015
Dec	LL	1200	2015

Your help is really appreciated.

Thanks,

Ram Krishna

[sunny_talwar]

But in your sample, your industry never repeats. There is a new industry name in all different months. I guess can you update the sample and provide the numerical output for each month?

[ramkrishna86]

This is a sample data loaded through inline table.

[sunny_talwar]

Sure, but why is there no industry repeating for more than a month? Do you get what I am trying to say

[ramkrishna86]

Industry can repeat, I have attached updated file with repeated industry.

[sunny_talwar · Accepted solution]

Here you go.... You will need to do some script manipulation to get this to work