topic Re: Get dates from week number in QlikView https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293080#M870255 <HTML><HEAD></HEAD><BODY><P>You don;t have Dates?</P><P>If you have dates then you would not need WEEK DATES. Unless you are going to make Week1 (which consists of 7 dates), Week2 (7dates) Week 3(7Dates) and so on....</P><P>What are you trying to achieve with the week dates?</P><P>You can maybe use </P><P>WeekStart(Date)as WKS</P><P>WeekEnd(Date) as WKE</P><P></P><P>To get start and end dates for the weeks and if you click on Week 1 it will select respective start and end dates from above fields.</P><P>And you'll have a Date Field which will give you all dates from that week.</P></BODY></HTML> Tue, 22 Nov 2016 19:44:58 GMT MK9885 2016-11-22T19:44:58Z Get dates from week number https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293078#M870253 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field WEEKNUMBER (which contains week numbers as 1,2,3 etc), and i want to get dates from that.</P><P></P><P>How can i achieve this ?</P><P></P><P></P><P>Thank you..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293078#M870253 mohan2391 2020-11-25T16:16:04Z Re: Get dates from week number https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293079#M870254 <HTML><HEAD></HEAD><BODY><P>May be use MakeWeekDate() function</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/makeweekdate.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/makeweekdate.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/makeweekdate.htm</A></P></BODY></HTML> Tue, 22 Nov 2016 18:01:03 GMT https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293079#M870254 sunny_talwar 2016-11-22T18:01:03Z Re: Get dates from week number https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293080#M870255 <HTML><HEAD></HEAD><BODY><P>You don;t have Dates?</P><P>If you have dates then you would not need WEEK DATES. Unless you are going to make Week1 (which consists of 7 dates), Week2 (7dates) Week 3(7Dates) and so on....</P><P>What are you trying to achieve with the week dates?</P><P>You can maybe use </P><P>WeekStart(Date)as WKS</P><P>WeekEnd(Date) as WKE</P><P></P><P>To get start and end dates for the weeks and if you click on Week 1 it will select respective start and end dates from above fields.</P><P>And you'll have a Date Field which will give you all dates from that week.</P></BODY></HTML> Tue, 22 Nov 2016 19:44:58 GMT https://community.qlik.com/t5/QlikView/Get-dates-from-week-number/m-p/1293080#M870255 MK9885 2016-11-22T19:44:58Z