topic Dimension Sort Order in QlikView https://community.qlik.com/t5/QlikView/Dimension-Sort-Order/m-p/490487#M1128133 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>I have a line chart showing sales per week. The dimension is Week which relates to the calendar week and I want it to run from week 19 to week 18 as this is the financial reporting period for the company.&nbsp; There is a field called WeekID where it shows 1 for week 19, 2 for week 20 and so on to 52 for week 18.&nbsp; On the chart properties I have sorted the dimension Week by Expression 'WeekID' which works until I use set analysis on the sales data. The expression I have used is sum({&lt;Week=,Month=&gt; Sales} as I want the graph to show the full year despite the week or month selected. As soon as I put this expression in, the weeks on the graph seemed to sort in a random order.</P></BODY></HTML> Mon, 16 Dec 2013 15:24:13 GMT Anonymous 2013-12-16T15:24:13Z Dimension Sort Order https://community.qlik.com/t5/QlikView/Dimension-Sort-Order/m-p/490487#M1128133 <HTML><HEAD></HEAD><BODY><P><BR />Hi</P><P></P><P>I have a line chart showing sales per week. The dimension is Week which relates to the calendar week and I want it to run from week 19 to week 18 as this is the financial reporting period for the company.&nbsp; There is a field called WeekID where it shows 1 for week 19, 2 for week 20 and so on to 52 for week 18.&nbsp; On the chart properties I have sorted the dimension Week by Expression 'WeekID' which works until I use set analysis on the sales data. The expression I have used is sum({&lt;Week=,Month=&gt; Sales} as I want the graph to show the full year despite the week or month selected. As soon as I put this expression in, the weeks on the graph seemed to sort in a random order.</P></BODY></HTML> Mon, 16 Dec 2013 15:24:13 GMT https://community.qlik.com/t5/QlikView/Dimension-Sort-Order/m-p/490487#M1128133 Anonymous 2013-12-16T15:24:13Z Re: Dimension Sort Order https://community.qlik.com/t5/QlikView/Dimension-Sort-Order/m-p/490488#M1128134 <HTML><HEAD></HEAD><BODY><P>Try a sort order expression like</P><P></P><P>=only({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Week=,Month=&gt; </SPAN>} WeekID)</P></BODY></HTML> Mon, 16 Dec 2013 15:29:47 GMT https://community.qlik.com/t5/QlikView/Dimension-Sort-Order/m-p/490488#M1128134 swuehl 2013-12-16T15:29:47Z