Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. 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.

1 Solution

Accepted Solutions
Vegar
Partner
Partner

Try this

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Vegar
Partner
Partner

Try this

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

apthansh
Creator
Creator

You are awesome.Thank you.