topic Re: Month order in QlikView https://community.qlik.com/t5/QlikView/Month-order/m-p/627009#M543051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Your document is corrupted.</P><P>Can you upload it again.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 05:59:50 GMT ashfaq_haseeb 2014-05-25T05:59:50Z Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627001#M543043 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>i am trying to show monthly statistics but i can't get the moths in order the chart is displayed like the image which i have shown below..</P><P>how can i get the correct order??</P><P>ex; Jan , Feb ,Mar, Apr, May... etc<IMG alt="Untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59482_Untitled.png" /></P><P>thank you in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 25 May 2014 05:27:11 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627001#M543043 2014-05-25T05:27:11Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627002#M543044 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to sort tab and play around with sorting there,</P><P>or post a sample app.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 05:29:36 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627002#M543044 ashfaq_haseeb 2014-05-25T05:29:36Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627003#M543045 <HTML><HEAD></HEAD><BODY><P>i did try every thing in the sorting tab but nothing worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Sun, 25 May 2014 05:32:54 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627003#M543045 2014-05-25T05:32:54Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627004#M543046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Sample app please</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 05:34:27 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627004#M543046 ashfaq_haseeb 2014-05-25T05:34:27Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627005#M543047 <HTML><HEAD></HEAD><BODY><P>i am using a personal edition so i dnt think u will be able to open it even if i post the sample app <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Sun, 25 May 2014 05:39:02 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627005#M543047 2014-05-25T05:39:02Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627006#M543048 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I can open any application as I have Licence.</P><P>But you cannot open any other application.</P><P>By seeing your application I can guide you.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 05:41:24 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627006#M543048 ashfaq_haseeb 2014-05-25T05:41:24Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627007#M543049 <HTML><HEAD></HEAD><BODY><P>Check your data source</P><P>Maybe your April Year is different than the others(let say 2015 to 2014 for Jan-May)</P></BODY></HTML> Sun, 25 May 2014 05:43:09 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627007#M543049 robert_mika 2014-05-25T05:43:09Z Re: Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627008#M543050 <HTML><HEAD></HEAD><BODY><P>i attached my Excel as well</P></BODY></HTML> Sun, 25 May 2014 05:57:15 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627008#M543050 2014-05-25T05:57:15Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627009#M543051 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Your document is corrupted.</P><P>Can you upload it again.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 05:59:50 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627009#M543051 ashfaq_haseeb 2014-05-25T05:59:50Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627010#M543052 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>go to sort tab select sort by expression --&gt; ascending order </P><P>Below is the expression. Make sure to select ascending order.</P><P></P><P></P><P>=match(YourMonthField, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec')</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 06:05:57 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627010#M543052 ashfaq_haseeb 2014-05-25T06:05:57Z Re: Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627011#M543053 <HTML><HEAD></HEAD><BODY><P>i have attached the Excel sheet also</P></BODY></HTML> Sun, 25 May 2014 06:07:28 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627011#M543053 2014-05-25T06:07:28Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627012#M543054 <HTML><HEAD></HEAD><BODY><P>Hi use this expression</P><P></P><P>=match(Month, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec') for sorting.</P><P></P><P>It works.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 25 May 2014 06:10:09 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627012#M543054 ashfaq_haseeb 2014-05-25T06:10:09Z Re: Month order https://community.qlik.com/t5/QlikView/Month-order/m-p/627013#M543055 <HTML><HEAD></HEAD><BODY><P>It worked thank you soooo much... really appreciate your help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sun, 25 May 2014 06:10:22 GMT https://community.qlik.com/t5/QlikView/Month-order/m-p/627013#M543055 2014-05-25T06:10:22Z