topic Populate values from above in QlikView https://community.qlik.com/t5/QlikView/Populate-values-from-above/m-p/699822#M252627 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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??</P><P></P><P>Thanks,<BR />Don</P></BODY></HTML> Mon, 15 Sep 2014 14:13:51 GMT don_qlikview 2014-09-15T14:13:51Z Populate values from above https://community.qlik.com/t5/QlikView/Populate-values-from-above/m-p/699822#M252627 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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??</P><P></P><P>Thanks,<BR />Don</P></BODY></HTML> Mon, 15 Sep 2014 14:13:51 GMT https://community.qlik.com/t5/QlikView/Populate-values-from-above/m-p/699822#M252627 don_qlikview 2014-09-15T14:13:51Z Re: Populate values from above https://community.qlik.com/t5/QlikView/Populate-values-from-above/m-p/699823#M252628 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 15 Sep 2014 14:17:15 GMT https://community.qlik.com/t5/QlikView/Populate-values-from-above/m-p/699823#M252628 JonnyPoole 2014-09-15T14:17:15Z