Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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