topic Last status record without NULL in QlikView https://community.qlik.com/t5/QlikView/Last-status-record-without-NULL/m-p/66100#M10971 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a problem with my set analysis. I want to find last status record like without Null</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">tradedate</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">closedate</TH></TR><TR><TD style="padding: 2px;">01-Jan-2018</TD><TD style="padding: 2px;">10-Dec-2017</TD></TR><TR><TD style="padding: 2px;">02-Jan-2018</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">03-Jan-2018</TD><TD style="padding: 2px;">-</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">04-Jan-2018</SPAN></TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>I want my result is</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>tradedate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Closedate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Closedate_Fix</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>01-Jan-2018</P></TD><TD style="padding: 2px;">10-Dec-2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">02-Jan-2018</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">03-Jan-2018</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">04-Jan-2018</SPAN></TD><TD>-</TD><TD><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR></TBODY></TABLE><P></P><P>I take one more column Closedate_Fix with expression:</P><P></P><P>if(isnull(CloseDate)&lt;&gt;0,FirstSortedValue({&lt; CloseDate = {'*'}&gt;}CloseDate, <SPAN style="font-size: 10pt;">-TradeDate),CloseDate)</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks for your help !<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Fri, 22 Jun 2018 09:34:55 GMT phongnnguyen 2018-06-22T09:34:55Z Last status record without NULL https://community.qlik.com/t5/QlikView/Last-status-record-without-NULL/m-p/66100#M10971 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a problem with my set analysis. I want to find last status record like without Null</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">tradedate</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">closedate</TH></TR><TR><TD style="padding: 2px;">01-Jan-2018</TD><TD style="padding: 2px;">10-Dec-2017</TD></TR><TR><TD style="padding: 2px;">02-Jan-2018</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">03-Jan-2018</TD><TD style="padding: 2px;">-</TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">04-Jan-2018</SPAN></TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>I want my result is</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>tradedate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Closedate</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Closedate_Fix</STRONG></TH></TR><TR><TD style="padding: 2px;"><P>01-Jan-2018</P></TD><TD style="padding: 2px;">10-Dec-2017</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">02-Jan-2018</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD style="padding: 2px;">03-Jan-2018</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR><TR><TD><SPAN style="font-size: 13.3333px;">04-Jan-2018</SPAN></TD><TD>-</TD><TD><SPAN style="font-size: 13.3333px;">10-Dec-2017</SPAN></TD></TR></TBODY></TABLE><P></P><P>I take one more column Closedate_Fix with expression:</P><P></P><P>if(isnull(CloseDate)&lt;&gt;0,FirstSortedValue({&lt; CloseDate = {'*'}&gt;}CloseDate, <SPAN style="font-size: 10pt;">-TradeDate),CloseDate)</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks for your help !<BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P></BODY></HTML> Fri, 22 Jun 2018 09:34:55 GMT https://community.qlik.com/t5/QlikView/Last-status-record-without-NULL/m-p/66100#M10971 phongnnguyen 2018-06-22T09:34:55Z Re: Last status record without NULL https://community.qlik.com/t5/QlikView/Last-status-record-without-NULL/m-p/66101#M10972 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(IsNull(CloseDate), FirstSortedValue(<SPAN style="color: #ff0000;">TOTAL</SPAN> {&lt;CloseDate = {'*'}&gt;} CloseDate, -TradeDate), CloseDate)</STRONG></P></BODY></HTML> Fri, 22 Jun 2018 11:36:41 GMT https://community.qlik.com/t5/QlikView/Last-status-record-without-NULL/m-p/66101#M10972 sunny_talwar 2018-06-22T11:36:41Z