3 Replies Latest reply: Dec 21, 2017 9:33 PM by Luis Madriz RSS

    Dear Qlik Experts: How to get the week number of each month and the date of each Monday each month?

    Michael Wallman

      Hello Qlik experts,

       

      I have a Date field from which I have created a MasterCalendar table.

       

      However I need to create two fields which I don't know how to:

       

      • Week number (e.g. week 1,2,3,4,5) for each month. This field would be called WeekNumberByMonth
      • Get the date of each Monday from that week. This would be called WeekDate

       

      Here is an example of week numbers that should be assigned based on real dates:

       

      January 2018:

      Week 1: 01/01/2018

      Week 2: 08/01/2018

      Week 3: 15/01/2018

      Week 4: 22/01/2018

      Week 5: 29/01/2018

       

      February 2018:

      Week 1: 05/02/2017

      Week 2: 12/02/2017

      Week 3: 19/02/2017

      Week 4: 26/02/2017

       

      March: 2018

      Week 1: 05/03/2017

      Week 2: 12/03/2017

      Week 3: 19/03/2017

      Week 4: 26/03/2017

       

      Each date above is a Monday of each week inside each month.

       

      Anyone know how I can create something like this please?