topic Re: Custom Sort in List Box in QlikView https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480355#M553081 <HTML><HEAD></HEAD><BODY><P>It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.</P><P></P><P>In the list box properties, you can also try a sort by expression:</P><P></P><P>=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')</P></BODY></HTML> Wed, 16 Oct 2013 16:41:52 GMT swuehl 2013-10-16T16:41:52Z Custom Sort in List Box https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480354#M553080 <HTML><HEAD></HEAD><BODY><P>Hiya, I have some text fields denoting Periods in my data set. These are labels as follows:</P><P>Pre-Project</P><P>Q1 2012</P><P>Q2 2012</P><P>Q3 2012</P><P>Q4 2012</P><P>Q1 2013 </P><P></P><P>I would like to custom sort them to they are in above order - but at present they won't do this (and either just go in load order or Q1 2012, Q1 2013 etc). Is there an expression I can use to sort these?</P><P></P><P>thanks</P></BODY></HTML> Wed, 16 Oct 2013 16:35:59 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480354#M553080 2013-10-16T16:35:59Z Re: Custom Sort in List Box https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480355#M553081 <HTML><HEAD></HEAD><BODY><P>It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.</P><P></P><P>In the list box properties, you can also try a sort by expression:</P><P></P><P>=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')</P></BODY></HTML> Wed, 16 Oct 2013 16:41:52 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480355#M553081 swuehl 2013-10-16T16:41:52Z Re: Custom Sort in List Box https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480356#M553082 <HTML><HEAD></HEAD><BODY><P>Brilliant that expression has resolved it! Thanks a lot for your help. </P></BODY></HTML> Thu, 17 Oct 2013 09:03:09 GMT https://community.qlik.com/t5/QlikView/Custom-Sort-in-List-Box/m-p/480356#M553082 2013-10-17T09:03:09Z