Interpreting Below Function

[anushree1]

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 ?

[dplr-rn · Accepted solution]

second parameter is the offset

 it moves n number of rows below  current one.

so 

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/InterReco...

[anushree1]

 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?

[sunny_talwar]

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.

[dplr-rn]

It gives you a range of values.

How many rows do you want from the offset

[anushree1]

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

[sunny_talwar · Accepted solution]

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