Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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