Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
ishanbansal1204
Contributor III
Contributor III

Running totals per dimension MonthYear

Hi Experts,

The Dataset is given below. I am facing a problem in getting the running total information.

I have a dimesnion Month_Year , I am stuck in the measure where I want to display all the <= values of the month which is displayed under dimesnion and product and dept are used as a filters

Please note this is not YTD - previous sum has to be calculated till the first value available.

Eg : For Jan - Value should be 30 and for feb value should be 75

DateMonth_yearProductDeptCount
1/1/2018Jan-18abcxyz10
2/1/2018Jan-18defpof20
1/2/2018Feb-18abcxyz25
2/2/2018Feb-18defpof20
Labels (3)
2 Replies
thannila
Creator
Creator

=Aggr(RangeSum(Above(sum(Count),0,Rowno())),Month_year)

Channa
Specialist III
Specialist III

=RangeSum(Above(TOTAL Count,0,AGGR(RowNo(),Dept,(Month_year,(NUMERIC,ASCENDING)))))

Channa