topic Re: Sort the month based on FinancialMonth in QlikView https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422892#M157600 <HTML><HEAD></HEAD><BODY><P>Dear Deepak.</P><P></P><P></P><P>Thank you.</P><P>it's working fine.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sun, 11 Nov 2012 09:34:29 GMT 2012-11-11T09:34:29Z Sort the month based on FinancialMonth https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422888#M157596 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>i want to sort the month based on financialmonth.(April,May,June ,,,,,,,,,,,,,,,,,,,,,,,,March)</P><P>i am able to sort it </P><P>.but on selection the selected month is moving to last right in the list box. </P><P>i don't want to move that month to last of the listbox.</P><P></P><P>find the attached sample.</P><P></P><P></P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sat, 10 Nov 2012 21:02:59 GMT https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422888#M157596 2012-11-10T21:02:59Z Re: Sort the month based on FinancialMonth https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422889#M157597 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Mukram,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Please see attached. You need to add Sort by state as "Ascending". So that your selections won't change the position and still you can sort by your FinancialMonth.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sun, 11 Nov 2012 00:16:40 GMT https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422889#M157597 IAMDV 2012-11-11T00:16:40Z Re: Sort the month based on FinancialMonth https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422890#M157598 <HTML><HEAD></HEAD><BODY><P>Dear Deepak.</P><P></P><P>Thanks for your reply.</P><P></P><P></P><P>when i did the sort state by 'Ascending' the selected Month is coming as first and order of month is changing.</P><P><IMG __jive_id="24935" class="jive-image-thumbnail jive-image" onclick="" alt="Month_Order.PNG" src="https://community.qlik.com/legacyfs/online/24935_Month_Order.PNG" width="450" /></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sun, 11 Nov 2012 06:37:04 GMT https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422890#M157598 2012-11-11T06:37:04Z Re: Sort the month based on FinancialMonth https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422891#M157599 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi Mukram,</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Sorry I misunderstood your requirement. You need to use this expression in sorting...</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">=only({1} FinancialMonth)</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Attaching the same.</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">DV</SPAN></P><P></P><P><A href="http://QlikShare.com"><SPAN style="font-family: calibri,verdana,arial,sans-serif;">www.QlikShare.com</SPAN></A></P></BODY></HTML> Sun, 11 Nov 2012 09:18:37 GMT https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422891#M157599 IAMDV 2012-11-11T09:18:37Z Re: Sort the month based on FinancialMonth https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422892#M157600 <HTML><HEAD></HEAD><BODY><P>Dear Deepak.</P><P></P><P></P><P>Thank you.</P><P>it's working fine.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Sun, 11 Nov 2012 09:34:29 GMT https://community.qlik.com/t5/QlikView/Sort-the-month-based-on-FinancialMonth/m-p/422892#M157600 2012-11-11T09:34:29Z