Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Expression ''Above''

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

Re: Expression ''Above''

Thank you!

Luminary
Luminary

Re: Expression ''Above''

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.

Community Browser