
Contributor II
2020-02-11
07:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik script - Using subtraction with a running total
Load * Inline [
Month,Budget,Forecast,Actual,Backlog
Jan-2020,17697527,239570,14507823,0
Feb-2020,17733064,408462,14947235,2785829
Mar-2020,4223912,322025,0,2463804
Apr-2020,3223889,490681,0,1973123
];
And I'm try to calculate the Backlog Remaining.
Jan-2020
Output = 0, it should calculate from current month
Feb-2020
Output = 2785829, If current month then Budget - Actual
Mar-2020
Output = 2463804, Output of Feb-2020 - Forecast (i.e. 2785829 - 322025 = 2463804)
Apr-2020
Output = 1973123, Output of Mar-2020 - Forecast (i.e. 2463804 - 490681 = 1973123)
Can anyone help me to achieve this output?
Let me know if any more information required for the same.
Thanks
Mayank Patel
808 Views
1 Reply

Contributor II
2021-11-05
03:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the "peek" function with "if" condition should be used.
566 Views
