topic Cumulative Total - Bar Chart Issue in App Development

Cumulative Total - Bar Chart Issue

Anonymous — Thu, 13 Jul 2017 09:29:21 GMT

Hi,

I've spent less than 1 hour in Qlik Sense Desktop and I'm already pulling my hair out!

I'm trying to create a bar chart with running totals however there are 2 dimensions. (Year and Month)

I would like each Year to be cumulative against the month but at the moment its producing a running total for everything.

This was a 1 Click solution in Qlik View so I'm not sure why the same hasn't been carried over.

I have tried Rangesum(above... functions but with no luck, only seems to work with 1 dimension.

Best Regards

Adam

Re: Cumulative Total - Bar Chart Issue

Anonymous — Thu, 13 Jul 2017 10:54:16 GMT

I have a work around where by i create 2 measures rather than one, still don't think this is the right way..

rangesum(above(TOTAL sum(if(INV_YEAR = 2016,VALUE_PRICE_CC,0)),0,ROWNO(TOTAL)))

rangesum(above(TOTAL sum(if(INV_YEAR = 2017,VALUE_PRICE_CC,0)),0,ROWNO(TOTAL)))

Re: Cumulative Total - Bar Chart Issue

sunny_talwar — Thu, 13 Jul 2017 15:18:00 GMT

I would suggest to use The As-Of Table as this might be the best way. Although, there are other alternatives also, but this will be the most efficient way to do it