Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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