topic Obtaining the last valid value in object expression in QlikView https://community.qlik.com/t5/QlikView/Obtaining-the-last-valid-value-in-object-expression/m-p/432126#M161105 <HTML><HEAD></HEAD><BODY><P>In the follwing how would I get the agency name of "ABC" even if I have selected year 2012:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="199"><TBODY><TR><TD class="xl64" height="20" width="55">Group</TD><TD class="xl64" width="66">Year</TD><TD class="xl64" width="78">Agency</TD></TR><TR><TD class="xl64" height="20">1</TD><TD class="xl64">2011</TD><TD class="xl64">ABC</TD></TR><TR><TD class="xl64" height="20">2</TD><TD class="xl64">2012</TD><TD class="xl64">ABC</TD></TR><TR><TD class="xl64" height="20">3</TD><TD class="xl64">2013</TD><TD class="xl64">-</TD></TR></TBODY></TABLE><P></P><P>Basically I want to populated an object with the last valid value for the agency field.</P><P></P><P>So even if I selected Year 2013 I could bring back the last know agency (from 2012) of "ABC".</P></BODY></HTML> Thu, 17 Jan 2013 20:47:16 GMT zagzebski 2013-01-17T20:47:16Z Obtaining the last valid value in object expression https://community.qlik.com/t5/QlikView/Obtaining-the-last-valid-value-in-object-expression/m-p/432126#M161105 <HTML><HEAD></HEAD><BODY><P>In the follwing how would I get the agency name of "ABC" even if I have selected year 2012:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="199"><TBODY><TR><TD class="xl64" height="20" width="55">Group</TD><TD class="xl64" width="66">Year</TD><TD class="xl64" width="78">Agency</TD></TR><TR><TD class="xl64" height="20">1</TD><TD class="xl64">2011</TD><TD class="xl64">ABC</TD></TR><TR><TD class="xl64" height="20">2</TD><TD class="xl64">2012</TD><TD class="xl64">ABC</TD></TR><TR><TD class="xl64" height="20">3</TD><TD class="xl64">2013</TD><TD class="xl64">-</TD></TR></TBODY></TABLE><P></P><P>Basically I want to populated an object with the last valid value for the agency field.</P><P></P><P>So even if I selected Year 2013 I could bring back the last know agency (from 2012) of "ABC".</P></BODY></HTML> Thu, 17 Jan 2013 20:47:16 GMT https://community.qlik.com/t5/QlikView/Obtaining-the-last-valid-value-in-object-expression/m-p/432126#M161105 zagzebski 2013-01-17T20:47:16Z