topic Day and Year in QlikView https://community.qlik.com/t5/QlikView/Day-and-Year/m-p/457825#M170946 <HTML><HEAD></HEAD><BODY><P>I have a bar chart whose Dimension is WeekYear (coming from Calendar table),</P><P></P><P>I need to plot (or display) it against Day And Year without losing above functionality. Calendar table currently does not have Day and Year concatenated.</P></BODY></HTML> Mon, 10 Jun 2013 20:31:27 GMT Anonymous 2013-06-10T20:31:27Z Day and Year https://community.qlik.com/t5/QlikView/Day-and-Year/m-p/457825#M170946 <HTML><HEAD></HEAD><BODY><P>I have a bar chart whose Dimension is WeekYear (coming from Calendar table),</P><P></P><P>I need to plot (or display) it against Day And Year without losing above functionality. Calendar table currently does not have Day and Year concatenated.</P></BODY></HTML> Mon, 10 Jun 2013 20:31:27 GMT https://community.qlik.com/t5/QlikView/Day-and-Year/m-p/457825#M170946 Anonymous 2013-06-10T20:31:27Z Re: Day and Year https://community.qlik.com/t5/QlikView/Day-and-Year/m-p/457826#M170947 <HTML><HEAD></HEAD><BODY><P>If your week is an ISO week, you can use this function:</P><P></P><P class="syntax"><A name="kanchor475"></A><A name="MakeWeekDate"></A><SPAN class="Bold">MakeWeekDate(</SPAN><SPAN class="Italic">YYYY [ , WW [ , D ] ] </SPAN><SPAN class="Bold">)</SPAN> </P><P class="syntax"></P><P>Returns a date calculated from the year <SPAN class="Italic">YYYY</SPAN>, the week <SPAN class="Italic">WW</SPAN> and the day-of-week <SPAN class="Italic">D</SPAN>. </P><P>If no day-of-week is stated, 0 (Monday) is assumed. </P><P class="example">Examples:</P><P><SPAN class="Code">makeweekdate(1999,6,6)</SPAN> returns 1999-02-14</P><P><SPAN class="Code">makeweekdate(1999,6)</SPAN> returns 1999-02-08</P></BODY></HTML> Mon, 10 Jun 2013 20:43:57 GMT https://community.qlik.com/t5/QlikView/Day-and-Year/m-p/457826#M170947 swuehl 2013-06-10T20:43:57Z