topic Week Number & Year in different field - convert to Week Commencing in QlikView https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439072#M1156931 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have two fields containing week numbers and year numbers.</P><P>How do i write an expression/formula to calculate a new field that will have a week commencing date?</P><P>Thanks</P><P>Simon <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 15 Feb 2013 10:24:18 GMT 2013-02-15T10:24:18Z Week Number & Year in different field - convert to Week Commencing https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439072#M1156931 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have two fields containing week numbers and year numbers.</P><P>How do i write an expression/formula to calculate a new field that will have a week commencing date?</P><P>Thanks</P><P>Simon <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 15 Feb 2013 10:24:18 GMT https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439072#M1156931 2013-02-15T10:24:18Z Re: Week Number & Year in different field - convert to Week Commencing https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439073#M1156932 <HTML><HEAD></HEAD><BODY><P>Plase check the date and time functions in QV's HELP, namely</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"><SPAN class="Bold"></SPAN> </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><SPAN style="font-style: normal;">If no day-of-week is stated, 0 (Monday) is assumed. </SPAN></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> Fri, 15 Feb 2013 11:45:02 GMT https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439073#M1156932 swuehl 2013-02-15T11:45:02Z Re: Week Number & Year in different field - convert to Week Commencing https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439074#M1156933 <HTML><HEAD></HEAD><BODY><P>Many Thanks - works fine !!</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 15 Feb 2013 11:48:26 GMT https://community.qlik.com/t5/QlikView/Week-Number-Year-in-different-field-convert-to-Week-Commencing/m-p/439074#M1156933 2013-02-15T11:48:26Z