Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Interpreting Below Function

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 ?

2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

View solution in original post

sunny_talwar

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

View solution in original post

6 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Specialist II
Specialist II
Author

 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
Partner - Master III
Partner - Master III

It gives you a range of values.

How many rows do you want from the offset

anushree1
Specialist II
Specialist II
Author

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

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