topic Reporting by Week over year end in QlikView https://community.qlik.com/t5/QlikView/Reporting-by-Week-over-year-end/m-p/769580#M1031357 <HTML><HEAD></HEAD><BODY><P>Dear community,</P><P></P><P>I'm looking to display data by week over year end. I've applied the =Week(Date) formula to get week numbers but I am struggling to sort the data in the correct order. My information is filtered using set analysis based on the dates to only show 13 weeks of information.</P><P></P><P>I want to order the weeks so that it would run 49,50,51,52,1,2,3,4,5 - then the next week would show 49,50,51,52,1,2,3,4,5,6 and so on.....</P><P></P><P>Many thanks for your help.</P><P></P><P>Best regards,</P><P></P><P>Drew</P></BODY></HTML> Mon, 09 Feb 2015 15:09:26 GMT 2015-02-09T15:09:26Z Reporting by Week over year end https://community.qlik.com/t5/QlikView/Reporting-by-Week-over-year-end/m-p/769580#M1031357 <HTML><HEAD></HEAD><BODY><P>Dear community,</P><P></P><P>I'm looking to display data by week over year end. I've applied the =Week(Date) formula to get week numbers but I am struggling to sort the data in the correct order. My information is filtered using set analysis based on the dates to only show 13 weeks of information.</P><P></P><P>I want to order the weeks so that it would run 49,50,51,52,1,2,3,4,5 - then the next week would show 49,50,51,52,1,2,3,4,5,6 and so on.....</P><P></P><P>Many thanks for your help.</P><P></P><P>Best regards,</P><P></P><P>Drew</P></BODY></HTML> Mon, 09 Feb 2015 15:09:26 GMT https://community.qlik.com/t5/QlikView/Reporting-by-Week-over-year-end/m-p/769580#M1031357 2015-02-09T15:09:26Z Re: Reporting by Week over year end https://community.qlik.com/t5/QlikView/Reporting-by-Week-over-year-end/m-p/769581#M1031358 <HTML><HEAD></HEAD><BODY><P>Try to order Weeks by expression Date.</P></BODY></HTML> Mon, 09 Feb 2015 15:18:12 GMT https://community.qlik.com/t5/QlikView/Reporting-by-Week-over-year-end/m-p/769581#M1031358 Anonymous 2015-02-09T15:18:12Z