Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Show Prev values if there is no data for current month

Hi All , 

 

i am trtrying to achieve one requirement in qlikview.

Example:

ID 1 Has data for 201901 - So for 201901 calculation should be Total - Bal is 10 and same value should carryforward to other months too as the ID doesn't have data for rest months

ID 2 has data for 201904 - So 201901 to 201903 should show Total value 42 and 201904 (42-16=26)  and 26 should be carry forwarded to rest of the months.

 

Thank 

 

3 Replies
subbareddykm
Creator II
Creator II
Author

Sample app

subbareddykm
Creator II
Creator II
Author

Input and outputInput and output

subbareddykm
Creator II
Creator II
Author

Hi All , 

 

Can anyone help to achieve this solution ?

 

Thank you