topic Re: how to get week number from date in qlik? in QlikView https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1709331#M879697 <P>Samir,</P><P>Greeting for day, very useful post.</P> Tue, 09 Jun 2020 10:34:01 GMT Sagar082 2020-06-09T10:34:01Z how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203754#M879692 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new to Qlik, try to achieve week number from date field.</P><P></P><P>tried with below formula and its gave wrong result, please advise. </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; WeekName(Date,0,-1) as week_no,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203754#M879692 2020-11-25T16:16:04Z Re: how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203755#M879693 <HTML><HEAD></HEAD><BODY><P>May be try as below:</P><P></P><P><SPAN class="Code">week( '1971-10-30' )</SPAN>&nbsp; will returns <SPAN class="Italic">43</SPAN>. </P></BODY></HTML> Thu, 06 Oct 2016 15:33:24 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203755#M879693 trdandamudi 2016-10-06T15:33:24Z Re: how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203756#M879694 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Week(fecha) = number week</P><P>weeknam(fecha) = year &amp; week </P></BODY></HTML> Thu, 06 Oct 2016 15:35:49 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203756#M879694 el_aprendiz111 2016-10-06T15:35:49Z Re: how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203757#M879695 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 7.5pt; font-family: Arial, sans-serif;">Try this one.</SPAN></P><P></P><P><SPAN style="font-size: 7.5pt; font-family: Arial, sans-serif;">=Week (Today ()) will result </SPAN>the current Week Number irrespective of Date.</P></BODY></HTML> Thu, 06 Oct 2016 15:36:31 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203757#M879695 gopikrishnach 2016-10-06T15:36:31Z Re: how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203758#M879696 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There's too many similar posts in this forum, please search before posting this type questions.</P><P></P><P>To answer this you can try:</P><P></P><OL class="dp-c" start="1" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #5c5c5c; margin: 0 0 1px 45px !important;"><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">LOAD *,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; Day(Date) as Day,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; WeekDay(Date) as WeekDay,&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; Week(Date) as Week,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; WeekName(Date) as WeekName,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; Month(Date) as Month,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; MonthName(Date) as MonthName,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; QuarterName(Date) as QuarterName,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; Year(Date) as Year,&nbsp; </SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">&nbsp;&nbsp;&nbsp; WeekYear(Date) as WeekYear;</SPAN></LI><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;">FROM Table.qvd(qvd);</SPAN></LI></OL><P></P><P>Hope it helps.</P><P></P><P>Regards,</P><P>Sakir</P></BODY></HTML> Thu, 06 Oct 2016 15:41:51 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1203758#M879696 2016-10-06T15:41:51Z Re: how to get week number from date in qlik? https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1709331#M879697 <P>Samir,</P><P>Greeting for day, very useful post.</P> Tue, 09 Jun 2020 10:34:01 GMT https://community.qlik.com/t5/QlikView/how-to-get-week-number-from-date-in-qlik/m-p/1709331#M879697 Sagar082 2020-06-09T10:34:01Z