Where can we use above and Below function?

[#1]

Hi there,

I am learning some Chart Inter Record Functions and saw "above" and "below" functions. I am just curious in reality, where should we use these two functions?

Thanks a lot,

Steve

[sunny_talwar]

We can use them in straight tables, charts, non-pivoted pivot tables (for pivoted dimensions, you can use After and Before). Here are some examples by Robert_Mika‌ -> Missing Manual - Above() and Below()

[#3]

Thanks Sunny! The examples are really good. Just curious in real business world, when we should apply these two functions?

[sunny_talwar]

One place it would be useful is to create a visual where you calculate Year-on-Year growth rate with year as your dimension.

[Mahamed_Qlik]

Hi Steve,

Just go through this :

The Above Function

Hope it will help.

Regards,

Mahamed

[#6]

Thanks Mahamed! I will read through it for sure.

Steve

[#7]

Thanks Sunny!

Have a great day,

Steve

[#8]

Very interesting, it looks Above (Sum(Sales),-1) is same as Below(Sum(Sales),1) and Above(Sum(Sales),1) is same as Below(Sum(Sales),-1).

Thanks for all the help guys!

Steve

[Mahamed_Qlik]

Exactly...

Enjoy your time...!

Mahamed.