Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression ''Above''

Hello people.

I need help me with the function ''Above'', what is your role? when do you use it?. Please, you can help me with definition?

Thank you

3 Replies
sunny_talwar

Robert_Mika‌ did an amazing job of explaining Above and Below function using example on this page: Missing Manual - Above() and Below()

I am sure you will find this useful

Best,

Sunny

Not applicable
Author

Thank you!

simondachstr
Luminary Alumni
Luminary Alumni

above(), same like below()/top()/bottom(), can be very useful to cross-reference your rows in a straight-table/pivot-table expression and sometimes a more simpler alternative to a very complex set analysis. However, at the same time you are very dependend on your dimensions in the respective chart. If rows are reduced e.g. by making a selection in the data model, then above() might return a completely different result than originally intended.