Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
shiveshsingh
Master
Master

Above Function

Hi

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

4 Replies
vishsaggi
Champion III
Champion III

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

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

balabhaskarqlik

Above function.png

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

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

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(....))