Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Cumulative expression Help

Hi All , 

i have requirement for this expression to be achieved in front end . Based on Data field i need the expression to be achieved data column . Kindly help

Data column expression is Sum( sales )

MonthDataExpression to be achieved
Jan1010
Feb2030
Mar3060
Apr40100
May50150
Jun60210

 

Labels (1)
1 Solution

Accepted Solutions
amrinder
Creator
Creator

Try this:

RangeSum(Above(Sum(Sales),0,RowNo()))

Hope it will help.
-amrinder

View solution in original post

2 Replies
amrinder
Creator
Creator

Try this:

RangeSum(Above(Sum(Sales),0,RowNo()))

Hope it will help.
-amrinder
kiranpatil123
Contributor III
Contributor III
Author

Thanks a lot for the reply and yeah i had done the same