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: 
apthansh
Creator
Creator

above() function

Hi - I have data as below

MonthSales
Jan100
feb200
March300

 

In the chart I wan to show increase on sales Month over Month.

So bar chart by Month and Jan will show 100, Feb will show 300 and March will show 600.

I TRIED ABOVE(SUM(SALES)) but this is not working.

Thank you for the help.

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try this

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

View solution in original post

2 Replies
Vegar
MVP
MVP

Try this

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

apthansh
Creator
Creator
Author

You are awesome.Thank you.