topic Re: sorting problems. in QlikView https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746627#M1042104 <HTML><HEAD></HEAD><BODY><P>hi, please check this great post from Barry</P><P><A href="http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/" title="http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/">Creating a custom sort order - The Qlik Fix! The Qlik Fix!</A></P><P></P><P>I personally like method 1</P></BODY></HTML> Mon, 01 Dec 2014 02:45:10 GMT Anonymous 2014-12-01T02:45:10Z sorting problems. https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746625#M1042102 <HTML><HEAD></HEAD><BODY><P>hello~</P><P>i have a problem with chart sort.</P><P></P><P>my bar chart is sorted by numeric in the dimension (hour)</P><P></P><P>ex) 00&nbsp;&nbsp; 01&nbsp;&nbsp; 02&nbsp;&nbsp; 03&nbsp;&nbsp; 04&nbsp;&nbsp; 05&nbsp;&nbsp; 06&nbsp;&nbsp; 07&nbsp;&nbsp; 08&nbsp;&nbsp; 09&nbsp; 10&nbsp; 11&nbsp; 12&nbsp;&nbsp; 13&nbsp;&nbsp; 14&nbsp;&nbsp; 15&nbsp;&nbsp; 16&nbsp;&nbsp; 17&nbsp;&nbsp; 18&nbsp; ~~~~ 23</P><P></P><P>but i want it</P><P></P><P>&nbsp;&nbsp; 07&nbsp;&nbsp; 08&nbsp;&nbsp;&nbsp; 09&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp; 12 ~~~~&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06</P><P></P><P>how can i do this??</P><P></P><P>please let me know.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 01 Dec 2014 01:15:03 GMT https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746625#M1042102 2014-12-01T01:15:03Z Re: sorting problems. https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746626#M1042103 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>You may use this custom sorting implementation on your dimension</P><P></P><P>PFA..</P><P></P><P>Best regards,</P><P>Chinna</P></BODY></HTML> Mon, 01 Dec 2014 02:41:34 GMT https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746626#M1042103 Anonymous 2014-12-01T02:41:34Z Re: sorting problems. https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746627#M1042104 <HTML><HEAD></HEAD><BODY><P>hi, please check this great post from Barry</P><P><A href="http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/" title="http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/">Creating a custom sort order - The Qlik Fix! The Qlik Fix!</A></P><P></P><P>I personally like method 1</P></BODY></HTML> Mon, 01 Dec 2014 02:45:10 GMT https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746627#M1042104 Anonymous 2014-12-01T02:45:10Z Re: sorting problems. https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746628#M1042105 <HTML><HEAD></HEAD><BODY><P>Hi Dear,</P><P></P><P>Create Inline field</P><P></P><P>Load * Inline [</P><P>Hour, SortOrder</P><P>00,06</P><P>01,07</P><P>02,08</P><P>03,09</P><P>04,10</P><P>05,11</P><P>06,12</P><P>07,01</P><P>08,02</P><P>09,03</P><P>10,04</P><P>11,05</P><P>];</P><P></P><P>map the field Hour to your Hour field.</P><P>In the chart properties, Sort tab, use sort by expression =only(SortOrder) </P><P>in ascending order.</P><P></P><P>Hope this will work.</P><P></P><P>Regards,</P><P>Lalit </P></BODY></HTML> Mon, 01 Dec 2014 06:32:05 GMT https://community.qlik.com/t5/QlikView/sorting-problems/m-p/746628#M1042105 2014-12-01T06:32:05Z