Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

Find nth row and continue calculation

 

Hello ,

I have a problem. I have a straight table and column names are 

Month,ID,INPUT,OUTPUT,ONHAND

Onhand formula is : peek(Onhand,-1) + input - output.

As you see there is no 202007 value so 202008 onhand value is wrong.

It must be 2 then after 202008 value's must be according to formula ;

202009      0

202010      -3

202011      -5

202012      5

202101      -2

nth row.PNG

Labels (3)
2 Replies
Channa
Specialist III
Specialist III

can you share little more sample data

Channa
QSense
Creator II
Creator II
Author

2020034013382-682P02P69-3
2020044013382-682P02P1034
2020054013382-682P02P664
2020064013382-682P02P462
2020084013382-682P02P55
2020094013382-682P02P 02-2
2020104013382-682P02P 03-5
2020114013382-682P02P2-7
2020124013382-682P02P1003
2021014013382-682P02P 07-4
2021024013382-682P02P 03-7