Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
This is a sample data loaded through inline table.
Sure, but why is there no industry repeating for more than a month? Do you get what I am trying to say
Industry can repeat, I have attached updated file with repeated industry.
Here you go.... You will need to do some script manipulation to get this to work