topic sort by month in QlikView https://community.qlik.com/t5/QlikView/sort-by-month/m-p/411929#M153356 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have a pivot table that has calendar week and weekday as dimension and then 3 formulas that show the date from selected date for the years 2010, 2011 and 2012. I want to sort my chart now by calendar week. it is not a problem from Feb-Nov cause there are no dates from the previous year. (I always show complete caledar weeks meaning from monday to sunday so if a month started on wedensday I'm still showing monday and tuesday from the previous month) so my problem now is if I sort by calender week ascending I have in january the 52 week at the end even though I need it at the beginning and the in december I have the first week at the beginning even though I need it at the end. </P><P></P><P>I tried sorting by formula (date) but qv doesnt sort it at all. </P><P></P><P>does anyone have an idea how I could solve this problem?</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Mon, 17 Sep 2012 08:53:06 GMT 2012-09-17T08:53:06Z sort by month https://community.qlik.com/t5/QlikView/sort-by-month/m-p/411929#M153356 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>I have a pivot table that has calendar week and weekday as dimension and then 3 formulas that show the date from selected date for the years 2010, 2011 and 2012. I want to sort my chart now by calendar week. it is not a problem from Feb-Nov cause there are no dates from the previous year. (I always show complete caledar weeks meaning from monday to sunday so if a month started on wedensday I'm still showing monday and tuesday from the previous month) so my problem now is if I sort by calender week ascending I have in january the 52 week at the end even though I need it at the beginning and the in december I have the first week at the beginning even though I need it at the end. </P><P></P><P>I tried sorting by formula (date) but qv doesnt sort it at all. </P><P></P><P>does anyone have an idea how I could solve this problem?</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Mon, 17 Sep 2012 08:53:06 GMT https://community.qlik.com/t5/QlikView/sort-by-month/m-p/411929#M153356 2012-09-17T08:53:06Z Re: sort by month https://community.qlik.com/t5/QlikView/sort-by-month/m-p/411930#M153357 <HTML><HEAD></HEAD><BODY><P>You should modify your calendar, create an OrderWeek that always week 1 starts on January and ends on 52/53 on December. </P><P></P><P>I had to make a calendar with sundays as first day of week, for example, things like this simplify the expressions a lot.</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 17 Sep 2012 18:42:58 GMT https://community.qlik.com/t5/QlikView/sort-by-month/m-p/411930#M153357 chematos 2012-09-17T18:42:58Z