topic Weekly Chart comparing this year(weeks) to an offset week last year in QlikView https://community.qlik.com/t5/QlikView/Weekly-Chart-comparing-this-year-weeks-to-an-offset-week-last/m-p/1096509#M640667 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been asked to produce a graph which uses the week number as dimension and compares this year to the last.</P><P></P><P>This is fine but ths business want to adjust the week numbers for last year so the periods align by weekday and (xmas vs xmas) etc.</P><P></P><P>I have attached the master calendar we are using to show how we would like the offset weeks defined but I am having serious trouble with the set analysis to compare the weeks.</P><P></P><P>Can anybody provide me with some guidance into how I might achieve this?</P><P></P><P>All the best,</P><P></P><P>HB</P></BODY></HTML> Fri, 04 Mar 2016 23:41:58 GMT 2016-03-04T23:41:58Z Weekly Chart comparing this year(weeks) to an offset week last year https://community.qlik.com/t5/QlikView/Weekly-Chart-comparing-this-year-weeks-to-an-offset-week-last/m-p/1096509#M640667 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have been asked to produce a graph which uses the week number as dimension and compares this year to the last.</P><P></P><P>This is fine but ths business want to adjust the week numbers for last year so the periods align by weekday and (xmas vs xmas) etc.</P><P></P><P>I have attached the master calendar we are using to show how we would like the offset weeks defined but I am having serious trouble with the set analysis to compare the weeks.</P><P></P><P>Can anybody provide me with some guidance into how I might achieve this?</P><P></P><P>All the best,</P><P></P><P>HB</P></BODY></HTML> Fri, 04 Mar 2016 23:41:58 GMT https://community.qlik.com/t5/QlikView/Weekly-Chart-comparing-this-year-weeks-to-an-offset-week-last/m-p/1096509#M640667 2016-03-04T23:41:58Z