https://community.qlik.com/t5/App-Development/How-to-get-week-number-in-months/m-p/1996375#M82499 <P>Hi Experts,</P> <P>I need small help on how to get week numbers from the respective months. I used the WEEK qlik function to get the week from the month (week(Date_Field)) I got the week number for year like 43,44. I really do not want in this way.</P> <P>I want in this way if I selected for example OCT-2022 month, it should show 1,2, 3,4 weeks of the oct-2022 and week should start from Monday and end with Sunday,</P> <P>can any one help on this pls?</P> <P>&nbsp;</P> Tue, 25 Oct 2022 04:09:03 GMT khadar 2022-10-25T04:09:03Z https://community.qlik.com/t5/App-Development/How-to-get-week-number-in-months/m-p/1996375#M82499 <P>Hi Experts,</P> <P>I need small help on how to get week numbers from the respective months. I used the WEEK qlik function to get the week from the month (week(Date_Field)) I got the week number for year like 43,44. I really do not want in this way.</P> <P>I want in this way if I selected for example OCT-2022 month, it should show 1,2, 3,4 weeks of the oct-2022 and week should start from Monday and end with Sunday,</P> <P>can any one help on this pls?</P> <P>&nbsp;</P> Tue, 25 Oct 2022 04:09:03 GMT https://community.qlik.com/t5/App-Development/How-to-get-week-number-in-months/m-p/1996375#M82499 khadar 2022-10-25T04:09:03Z https://community.qlik.com/t5/App-Development/How-to-get-week-number-in-months/m-p/1996377#M82500 <P>I find it a bit troublesome to work with weeks in combination with months as there is no clean relationships between the two. A month can start on any weekday and stretch over a different amount of weeks.</P> <P>To solve this you could try to use the difference between the week of your date and the week of the start of the month. Like this:</P> <P>week(DateField)-week(monthstart(DateField))+1</P> Tue, 25 Oct 2022 05:04:00 GMT https://community.qlik.com/t5/App-Development/How-to-get-week-number-in-months/m-p/1996377#M82500 Vegar 2022-10-25T05:04:00Z