# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Running Sum and Total regardless of the year/month

Hi All,

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()))

 Year Month Measure1 2011 Jan 0 2011 Feb 0 2011 Mar 0 2011 Apr 29 2011 May 109 2011 Jun 235 2011 Jul 278 2011 Aug 490 2011 Sep 524 2011 Oct 531 2011 Nov 699 2011 Dec 810 2012 Jan 14 2012 Feb 148 2012 Mar 378 2012 Apr 479 2012 May 670 2012 Jun 1014 2012 Jul 1241 2012 Aug 1787 2012 Sep 1941 2012 Oct 2217 2012 Nov 2290 2012 Dec 2352 2013 Jan 8

Can anyone suggest how to attain running sum and total regardless of the month and year?

Tags (1)
1 Solution

Accepted Solutions
Valued Contributor III

## Re: Running Sum and Total regardless of the year/month

Hi, try this expression:

rangesum(above(TOTAL round(sum(if(Match(Status,'A','B') and Typ='AB',Measure1,0))),0,rowno(TOTAL)))

JV

4 Replies
MVP

## Re: Running Sum and Total regardless of the year/month

Are you trying to do this in a pivot table where Months are pivoted??

Valued Contributor III

## Re: Running Sum and Total regardless of the year/month

Hi, try this expression:

rangesum(above(TOTAL round(sum(if(Match(Status,'A','B') and Typ='AB',Measure1,0))),0,rowno(TOTAL)))

JV

Not applicable

## Re: Running Sum and Total regardless of the year/month

Yes, I was using Pivot table

Not applicable

## Re: Running Sum and Total regardless of the year/month

Many thanks Juan, It worked perfectly.