topic Sorting group dimension by year then month in QlikView https://community.qlik.com/t5/QlikView/Sorting-group-dimension-by-year-then-month/m-p/377677#M140802 <HTML><HEAD></HEAD><BODY><P>hi everyone, </P><P></P><P>I have a dimension that is a group. One of the fields in the group is the monthyear. </P><P></P><P>what I would like to do is sort it by year then month so that I get:</P><P></P><P>Apr2011, May2011....Apr2012, Jun2012. </P><P></P><P>Currntly I am getting this: - </P><P></P><P><IMG __jive_id="20131" class="jive-image-thumbnail jive-image" height="102" onclick="" alt="01.bmp" src="https://community.qlik.com/legacyfs/online/20131_01.bmp" width="735" /></P><P></P><P>I tried to sort by full_date (a field whichis teh date in the format dd/mm/yyyy) but it gave teh above. I also tried sorting numeric and get the same. </P><P></P><P>Does anyone have a suggestion?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 14 Aug 2012 11:26:28 GMT 2012-08-14T11:26:28Z Sorting group dimension by year then month https://community.qlik.com/t5/QlikView/Sorting-group-dimension-by-year-then-month/m-p/377677#M140802 <HTML><HEAD></HEAD><BODY><P>hi everyone, </P><P></P><P>I have a dimension that is a group. One of the fields in the group is the monthyear. </P><P></P><P>what I would like to do is sort it by year then month so that I get:</P><P></P><P>Apr2011, May2011....Apr2012, Jun2012. </P><P></P><P>Currntly I am getting this: - </P><P></P><P><IMG __jive_id="20131" class="jive-image-thumbnail jive-image" height="102" onclick="" alt="01.bmp" src="https://community.qlik.com/legacyfs/online/20131_01.bmp" width="735" /></P><P></P><P>I tried to sort by full_date (a field whichis teh date in the format dd/mm/yyyy) but it gave teh above. I also tried sorting numeric and get the same. </P><P></P><P>Does anyone have a suggestion?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 14 Aug 2012 11:26:28 GMT https://community.qlik.com/t5/QlikView/Sorting-group-dimension-by-year-then-month/m-p/377677#M140802 2012-08-14T11:26:28Z