topic Interpreting Below Function in QlikView

Interpreting Below Function

anushree1 — Thu, 30 Jul 2020 14:12:57 GMT

HI,

Can someone explain how and where below is used with the second parameter like below(sum(sales),3,2)

I understand below(sum(sales),3), but what does the next parameter 2 do ?

Re: Interpreting Below Function

dplr-rn — Thu, 30 Jul 2020 14:34:47 GMT

second parameter is the offset

it moves n number of rows below current one.

without offset is same as offset=1 below(sum(sales)) the row below

below(sum(sales),3) 3 rows below current one

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/below.htm

Re: Interpreting Below Function

anushree1 — Fri, 07 Aug 2020 08:05:04 GMT

HI Dilip,

As stated in the question , I understand the second parameter but my confusion is on the 3rd parameter and what it is used for?

Re: Interpreting Below Function

sunny_talwar — Fri, 07 Aug 2020 11:55:04 GMT

Third is used when you are using Above/Below/Before/After functions with RangeSum or RangeAvg or any other Range function to determine how many value from behind/ahead do you want to sum in the current row. For example, for rolling 12 months avg, you would use RangeAvg with a third parameter of 12.

Re: Interpreting Below Function

dplr-rn — Fri, 07 Aug 2020 11:56:40 GMT

It gives you a range of values.

How many rows do you want from the offset

Re: Interpreting Below Function

anushree1 — Fri, 07 Aug 2020 12:55:42 GMT

hi,

We are not using any range functions its just below with 3 parameters

as per the help file it is like:

Below([TOTAL] expr [ , offset [,count ]])

and I do not understand what the optional count is for

Re: Interpreting Below Function

sunny_talwar — Fri, 07 Aug 2020 17:54:03 GMT

If you are not using RangeSum, third parameter is not applicable for you 🙂