topic Weekstart and multiple years in Combo Chart problem when comparing weeks in QlikView https://community.qlik.com/t5/QlikView/Weekstart-and-multiple-years-in-Combo-Chart-problem-when/m-p/477852#M178478 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a problem in the presentation of the data in a combochart.</P><P>The combochart looks like this:</P><P>current year data in bars</P><P>previous year in a line</P><P>the data is grouped per week (weeknumber)</P><P></P><P>Eveyrthing looks fine, except that when I use this formula in the dimension tab</P><P>=dual(WeekStart([Date]), Week(Date))</P><P></P><P>It shows the first Monday of every week of the previous year.</P><P>I would like to see the first Monday of every week of the CURRENT year.</P><P></P><P>I've attached the (sample) application.</P><P></P><P>Best regards,</P><P>Arjan</P></BODY></HTML> Fri, 22 Nov 2013 12:57:44 GMT 2013-11-22T12:57:44Z Weekstart and multiple years in Combo Chart problem when comparing weeks https://community.qlik.com/t5/QlikView/Weekstart-and-multiple-years-in-Combo-Chart-problem-when/m-p/477852#M178478 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a problem in the presentation of the data in a combochart.</P><P>The combochart looks like this:</P><P>current year data in bars</P><P>previous year in a line</P><P>the data is grouped per week (weeknumber)</P><P></P><P>Eveyrthing looks fine, except that when I use this formula in the dimension tab</P><P>=dual(WeekStart([Date]), Week(Date))</P><P></P><P>It shows the first Monday of every week of the previous year.</P><P>I would like to see the first Monday of every week of the CURRENT year.</P><P></P><P>I've attached the (sample) application.</P><P></P><P>Best regards,</P><P>Arjan</P></BODY></HTML> Fri, 22 Nov 2013 12:57:44 GMT https://community.qlik.com/t5/QlikView/Weekstart-and-multiple-years-in-Combo-Chart-problem-when/m-p/477852#M178478 2013-11-22T12:57:44Z