topic Sorting a calculated dimensions in a chart in QlikView https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206330#M62493 <HTML><HEAD></HEAD><BODY><P>You are creating a text field with the concatenation of Month and Year. I would suggest using the following calculated Dimension instead:</P><P>=MonthName(DateField)</P><P>This will give you the Month and Year as required but keep it in underlying numeric date format so you can choose 'Numeric Value' as sort option on the dimension.</P><P></P></BODY></HTML> Fri, 08 Apr 2011 17:03:31 GMT nathanfurby 2011-04-08T17:03:31Z Sorting a calculated dimensions in a chart https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206329#M62492 <HTML><HEAD></HEAD><BODY><P class="MsoNoSpacing">I have a pivot table where I have the calculated dimension</P><P class="MsoNoSpacing"></P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">=month&amp;' '&amp;year</P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">I have dragged this dimension within the pivot table so that the month &amp; year appear horizontally. The problem is that I cannot get it to sort by month. When I just use the month as a dimension it sorts fine.</P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">Do I need to have an expression in Properties -&gt; Sort?</P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">Any guidance would be greatly appreciated.</P></BODY></HTML> Fri, 08 Apr 2011 16:53:06 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206329#M62492 2011-04-08T16:53:06Z Sorting a calculated dimensions in a chart https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206330#M62493 <HTML><HEAD></HEAD><BODY><P>You are creating a text field with the concatenation of Month and Year. I would suggest using the following calculated Dimension instead:</P><P>=MonthName(DateField)</P><P>This will give you the Month and Year as required but keep it in underlying numeric date format so you can choose 'Numeric Value' as sort option on the dimension.</P><P></P></BODY></HTML> Fri, 08 Apr 2011 17:03:31 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206330#M62493 nathanfurby 2011-04-08T17:03:31Z Sorting a calculated dimensions in a chart https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206331#M62494 <HTML><HEAD></HEAD><BODY><P>This worked - thanks!</P></BODY></HTML> Fri, 08 Apr 2011 17:30:31 GMT https://community.qlik.com/t5/QlikView/Sorting-a-calculated-dimensions-in-a-chart/m-p/206331#M62494 2011-04-08T17:30:31Z