topic Re: Get last available value if NULL in App Development

topic Re: Get last available value if NULL in App Development https://community.qlik.com/t5/App-Development/Get-last-available-value-if-NULL/m-p/93321#M6222 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <BR /> </SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">IF</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Len</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Trim</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">))<1,</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Peek</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">as</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P></BODY></HTML> Thu, 20 Sep 2018 14:05:08 GMT vamsee 2018-09-20T14:05:08Z Get last available value if NULL https://community.qlik.com/t5/App-Development/Get-last-available-value-if-NULL/m-p/93320#M6221 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I have list of dates with corresponding information(value) in a table in Qliksense.</P><P></P><P>If the value is NULL i want to list the last available value in my table</P><P></P><P>example: Input</P><P>Date               Value</P><P>1/2/2018          2</P><P>2/2/2018          -</P><P>3/3/2018          -</P><P>4/8/2018          10</P><P><SPAN style="font-size: 13.3333px;">10/8/2018         -</SPAN></P><P><SPAN style="font-size: 13.3333px;">12/8/2018          -</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Output:</SPAN></P><P style="font-size: 13.3333px;">Date               Value</P><P style="font-size: 13.3333px;">1/2/2018          2</P><P style="font-size: 13.3333px;">2/2/2018          2</P><P style="font-size: 13.3333px;">3/3/2018          2</P><P style="font-size: 13.3333px;">4/8/2018          10</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">10/8/2018         10</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">12/8/2018          10</SPAN></P><P></P><P>Thanks,</P><P>Monu</P></BODY></HTML> Thu, 20 Sep 2018 13:48:42 GMT https://community.qlik.com/t5/App-Development/Get-last-available-value-if-NULL/m-p/93320#M6221 sarasmonu 2018-09-20T13:48:42Z Re: Get last available value if NULL https://community.qlik.com/t5/App-Development/Get-last-available-value-if-NULL/m-p/93321#M6222 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 10pt;"> <BR /> </SPAN><SPAN style="color: #800000; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">,<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">IF</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Len</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Trim</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">))<1,</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">Peek</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">), </SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">as</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #800000; font-size: 10pt;">Value</SPAN><SPAN style="font-size: 10pt;">; </SPAN></P><P></P></BODY></HTML> Thu, 20 Sep 2018 14:05:08 GMT https://community.qlik.com/t5/App-Development/Get-last-available-value-if-NULL/m-p/93321#M6222 vamsee 2018-09-20T14:05:08Z