How to get upper row value in current row

[Rajkumar]

Hi every one ,

I want achieve below results in set analysis. can any one help me?

Input:

DAY	SALES
1	500
2	400
3	200
4	400
5	300

Output:

DAY	SALES
1	500
2	400
3	40% (day 3/day1)
4	400
5	75 %(day 5/day4)

[RadovanOresky]

Hi, I believe that Above() function could help you, if you have that data already in a straight table object.

You can define an offset parameter, that will enable you to skip rows.

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterReco...

Hope it helps,

-RADO-

[Zhandos_Shotan]

Hi

Cannot understand your output table for day3 and day5 rows.

But answer to title question is Above() function with offset parameter.

Read more: 

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterReco...