topic Re: Where can we use above and Below function? in QlikView

Where can we use above and Below function?

Thu, 21 Jan 2016 20:30:27 GMT

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

Re: Where can we use above and Below function?

sunny_talwar — Thu, 21 Jan 2016 21:09:10 GMT

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

Re: Where can we use above and Below function?

Thu, 21 Jan 2016 21:29:51 GMT

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

Re: Where can we use above and Below function?

sunny_talwar — Thu, 21 Jan 2016 23:02:32 GMT

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

Re: Where can we use above and Below function?

Mahamed_Qlik — Fri, 22 Jan 2016 06:53:54 GMT

Hi Steve,

Just go through this :

The Above Function

Hope it will help.

Regards,

Mahamed

Re: Where can we use above and Below function?

Fri, 22 Jan 2016 14:47:24 GMT

Thanks Mahamed! I will read through it for sure.

Steve

Re: Where can we use above and Below function?

Fri, 22 Jan 2016 14:48:49 GMT

Thanks Sunny!

Have a great day,

Steve

Re: Where can we use above and Below function?

Fri, 22 Jan 2016 15:57:55 GMT

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

Re: Where can we use above and Below function?

Mahamed_Qlik — Mon, 25 Jan 2016 06:34:32 GMT

Exactly...

Enjoy your time...!

Mahamed.