Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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
Former Employee
Former 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.