topic Re: sorting with the required year in QlikView https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083082#M360741 <HTML><HEAD></HEAD><BODY><P>Can you attached sample file here to look out.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 16 Mar 2016 08:19:46 GMT its_anandrjs 2016-03-16T08:19:46Z sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083078#M360737 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>i am new to qlikview and i got a problem while working on the charts</P><P></P><P>my chart in the x-axis showing the format mmm-yy and it is starting from feb-10 and i want to see the start date as feb-12 </P><P></P><P>can any one please help me on this issue !</P></BODY></HTML> Wed, 16 Mar 2016 07:21:23 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083078#M360737 2016-03-16T07:21:23Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083079#M360738 <HTML><HEAD></HEAD><BODY><P>can u attach ur sample?</P></BODY></HTML> Wed, 16 Mar 2016 08:02:03 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083079#M360738 Chanty4u 2016-03-16T08:02:03Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083080#M360739 <HTML><HEAD></HEAD><BODY><P>instead of formatting your date dimension use MonthName(your_date_column) this could help</P><P>or give a sample document to check your data and I can look into it cause when you format your date field the result will be a string and sorting on string values will be not logical</P></BODY></HTML> Wed, 16 Mar 2016 08:03:11 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083080#M360739 ali_hijazi 2016-03-16T08:03:11Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083081#M360740 <HTML><HEAD></HEAD><BODY><P>if it is max date&nbsp; use max(ur date field)</P></BODY></HTML> Wed, 16 Mar 2016 08:15:01 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083081#M360740 Chanty4u 2016-03-16T08:15:01Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083082#M360741 <HTML><HEAD></HEAD><BODY><P>Can you attached sample file here to look out.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Wed, 16 Mar 2016 08:19:46 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083082#M360741 its_anandrjs 2016-03-16T08:19:46Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083083#M360742 <HTML><HEAD></HEAD><BODY><P>plz share screen shot and sample data...</P></BODY></HTML> Wed, 16 Mar 2016 09:36:04 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083083#M360742 Anonymous 2016-03-16T09:36:04Z Re: sorting with the required year https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083084#M360743 <HTML><HEAD></HEAD><BODY><P>according to your requirement you can add the expression in the sort tab and try with the same....if your not able to achieve the same please share the same data format and the required output format </P></BODY></HTML> Wed, 16 Mar 2016 09:39:10 GMT https://community.qlik.com/t5/QlikView/sorting-with-the-required-year/m-p/1083084#M360743 avinashelite 2016-03-16T09:39:10Z