Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Highlighted

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

View solution in original post

6 Replies
Highlighted
Partner
Partner

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

Highlighted
Specialist II
Specialist II

 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?

Highlighted

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.

Highlighted
Partner
Partner

It gives you a range of values.

How many rows do you want from the offset

Highlighted
Specialist II
Specialist II

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

Highlighted

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

View solution in original post