topic Motnh Sort in QlikView https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248077#M94446 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I created a list box using the month in my dataset. But how do I sort it? I want the months to be sorted in the order Jan, Feb.. etc.</P><P></P><P><IMG alt="untitled.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/7130_untitled.JPG" /></P><P></P><P>Please help, thanks in advance!</P></BODY></HTML> Thu, 08 Sep 2011 16:49:29 GMT 2011-09-08T16:49:29Z Motnh Sort https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248077#M94446 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I created a list box using the month in my dataset. But how do I sort it? I want the months to be sorted in the order Jan, Feb.. etc.</P><P></P><P><IMG alt="untitled.JPG" class="jive-image" src="https://community.qlik.com/legacyfs/online/7130_untitled.JPG" /></P><P></P><P>Please help, thanks in advance!</P></BODY></HTML> Thu, 08 Sep 2011 16:49:29 GMT https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248077#M94446 2011-09-08T16:49:29Z Motnh Sort https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248078#M94447 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how have you generated the Month field? Using the Month() function or loading the field from a data source?</P></BODY></HTML> Thu, 08 Sep 2011 16:59:44 GMT https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248078#M94447 swuehl 2011-09-08T16:59:44Z Re: Motnh Sort https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248079#M94448 <HTML><HEAD></HEAD><BODY><P>If field format is date then sort by value as usual number.</P><P></P><P>If string - you should create one more field with month number and sort first field by second field.</P><P></P><P>UPDATE</P><P></P><P>By the way -- on your screenshot Month is already sorted. Just in wrong direction.</P></BODY></HTML> Thu, 08 Sep 2011 18:43:41 GMT https://community.qlik.com/t5/QlikView/Motnh-Sort/m-p/248079#M94448 2011-09-08T18:43:41Z