Skip to main content
Sept. 27, 10AM ET Do more with Qlik, Insight Advisor – our intelligent AI-assistant in Qlik Sense: Register
Showing results for 
Search instead for 
Did you mean: 

Above Function


please check attached images, why February is missing in above statement?

4 Replies
Champion III
Champion III

Can you share your complete sum() expression with Above()

Are you using like Above(Sum(Sales), 0, RowNo()) ?


Above function.png

Can you please let us know what's your complete Above() expression?


Because, You are calculating with Previous one to previous one. Sum(Sales) - Above(...) will return correct only but not the starting stage or sequance

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Simple answer to your question is that, February doesn't show because the data isn't sorted in the right sort order. If the sort was done correctly, then January would not have shown. Is that something you want or do you even want to see January for 2014 and 2015? (2013 won't show because you don't have 2012 data)...but for 2014, you can try your above function with a total

Above(TOTAL Sum(....))