topic Re: Sorting Y-Axis on Chart (Years and Months) in QlikView https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457529#M170806 <HTML><HEAD></HEAD><BODY><P>Youmay try using the sort expression</P><P></P><P>year_index &amp; month_index</P></BODY></HTML> Tue, 08 Jan 2013 14:40:06 GMT nagaiank 2013-01-08T14:40:06Z Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457524#M170801 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im having trouble sorting my y-axis on a chart.&nbsp; Im my dataset I have the following date identifiers :</P><P></P><P>(<EM>Years are Financial Year - Apr-Mar</EM>)</P><P></P><UL><LI>year_index (1,2,3,4)</LI><LI>montth_index (1-12)</LI><LI>Month (Apr, May....Mar)</LI><LI>Year (2010/11, 2011/12, 2012/13)</LI></UL><P></P><P>What ever I do to try and sort the y-axis - nothing seems to work.</P><P></P><P>Any help appreciated.</P><P></P><P>Fiorano</P></BODY></HTML> Thu, 20 Dec 2012 15:08:50 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457524#M170801 2012-12-20T15:08:50Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457525#M170802 <HTML><HEAD></HEAD><BODY><P>Anyone? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Tue, 08 Jan 2013 11:55:42 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457525#M170802 2013-01-08T11:55:42Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457526#M170803 <HTML><HEAD></HEAD><BODY><P>In sort tab go to expression in that write by using match r wildmatch function it will work. </P><P></P><P>Give some sample data i will write expression.</P></BODY></HTML> Tue, 08 Jan 2013 12:01:25 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457526#M170803 khadeer 2013-01-08T12:01:25Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457527#M170804 <HTML><HEAD></HEAD><BODY><P>=match(Month,'Apr','May','Jun','Jul','Aug','Sep'.......'Mar')</P><P></P><P></P><P>it will help u</P></BODY></HTML> Tue, 08 Jan 2013 12:10:24 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457527#M170804 khadeer 2013-01-08T12:10:24Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457528#M170805 <HTML><HEAD></HEAD><BODY><P>Hi this does help when viewing a single financial year. When I deselect the year filter the Months and financial years are combined eg Apr-2010, Apr-2011, Apr-2012, Feb-2010, Feb-2011 etc...</P></BODY></HTML> Tue, 08 Jan 2013 14:24:41 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457528#M170805 2013-01-08T14:24:41Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457529#M170806 <HTML><HEAD></HEAD><BODY><P>Youmay try using the sort expression</P><P></P><P>year_index &amp; month_index</P></BODY></HTML> Tue, 08 Jan 2013 14:40:06 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457529#M170806 nagaiank 2013-01-08T14:40:06Z Re: Sorting Y-Axis on Chart (Years and Months) https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457530#M170807 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Tue, 08 Jan 2013 16:18:13 GMT https://community.qlik.com/t5/QlikView/Sorting-Y-Axis-on-Chart-Years-and-Months/m-p/457530#M170807 2013-01-08T16:18:13Z