topic Re: Weird sorting problem... in QlikView https://community.qlik.com/t5/QlikView/Weird-sorting-problem/m-p/402114#M563225 <HTML><HEAD></HEAD><BODY><P>Using dual you can define a text and number attributes for each field value. That's usually what's done for month jan, feb, mar are actually 1,2,3 and they are always sorte.</P><P></P><P>That way your seasons will behave like a number and will always be sorted, in every selector or chart.</P><P></P><P>Please see the attachment</P></BODY></HTML> Tue, 05 Feb 2013 00:56:10 GMT danielrozental 2013-02-05T00:56:10Z Weird sorting problem... https://community.qlik.com/t5/QlikView/Weird-sorting-problem/m-p/402113#M563224 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a simple table with "season codes" like S12, S13, W12, W13, etc and I need them to be sorted descending using this expression:</P><P>=right(Season, 2) &amp; left(Season, 1)</P><P>resulting in something like W13, S13, W12, S12 etc</P><P></P><P>What I get in QV is completely messed up instead...</P><P></P><P>Please check the QVW attached and let me know if I'm doing something wrong.</P><P></P><P>Thank you,</P><P>Roberto</P></BODY></HTML> Mon, 04 Feb 2013 22:09:34 GMT https://community.qlik.com/t5/QlikView/Weird-sorting-problem/m-p/402113#M563224 2013-02-04T22:09:34Z Re: Weird sorting problem... https://community.qlik.com/t5/QlikView/Weird-sorting-problem/m-p/402114#M563225 <HTML><HEAD></HEAD><BODY><P>Using dual you can define a text and number attributes for each field value. That's usually what's done for month jan, feb, mar are actually 1,2,3 and they are always sorte.</P><P></P><P>That way your seasons will behave like a number and will always be sorted, in every selector or chart.</P><P></P><P>Please see the attachment</P></BODY></HTML> Tue, 05 Feb 2013 00:56:10 GMT https://community.qlik.com/t5/QlikView/Weird-sorting-problem/m-p/402114#M563225 danielrozental 2013-02-05T00:56:10Z