Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist III
Specialist III

can you share little more sample data

Channa
Highlighted
Creator II
Creator II

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