topic Re: Sort by date - Replaced Nulls with text in QlikView https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410254#M559848 <HTML><HEAD></HEAD><BODY><P>That did it! Thank you</P></BODY></HTML> Mon, 29 Apr 2013 19:48:03 GMT 2013-04-29T19:48:03Z Sort by date - Replaced Nulls with text https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410252#M559846 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a field that contains dates.&nbsp; The date will sometimes be null, so I replaced nulls with "Open" in the script.&nbsp; </P><P></P><P>I have a bar chart where I want the dates to be in ascending order, but "Open" to be last, not first.</P><P></P><P>It is currently sorting it as: Open, Jan 2013, Feb 2013, Mar 2013, etc.&nbsp; I want the dates to stay in this order, but Open to appear at the end, not the beginning.</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 29 Apr 2013 15:51:51 GMT https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410252#M559846 2013-04-29T15:51:51Z Re: Sort by date - Replaced Nulls with text https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410253#M559847 <HTML><HEAD></HEAD><BODY><P>In the Chart properies, Sort tab, sort date by the followint expression ascending:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P>If<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">='Open',999999,</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Mon, 29 Apr 2013 19:05:12 GMT https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410253#M559847 nagaiank 2013-04-29T19:05:12Z Re: Sort by date - Replaced Nulls with text https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410254#M559848 <HTML><HEAD></HEAD><BODY><P>That did it! Thank you</P></BODY></HTML> Mon, 29 Apr 2013 19:48:03 GMT https://community.qlik.com/t5/QlikView/Sort-by-date-Replaced-Nulls-with-text/m-p/410254#M559848 2013-04-29T19:48:03Z