This content has been marked as final. Show 4 replies
I'm new to Qlik and trying to explore the tool.
I have requirement, where need to do running sum(measure) for each month. I was able to attain running sum but for every year sum get reset. Please look at the below table. Sum got resets for year 2012 and 2013
The following formula is used
rangesum(above(round(sum(if(Match(Status,'A','B') and Typ='AB',Measure1,0))),0,rowno()))
Can anyone suggest how to attain running sum and total regardless of the month and year?