Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
don_qlikview
Creator
Creator

Populate values from above

Hello,

I have this table where i have to populate the '0' values from above values. I tried using the above() but it seems it works only one time. For example if have a value on first row and the below 2 rows are empty then the second row gets filled by above() but not the third. I am using three other list boxes namely Year, Type and PC Name as a filter to get to the values shown in the attachment. So, can anyone help me how i can populate the other rows??

Thanks,
Don

1 Reply
JonnyPoole
Employee
Employee

you may need to use the range functions to check multiple rows above but i'd like to see you QVW test example before being confident in a solution. Attach it if you can.