master Calender

[qlikapple]

I have master calender

 like year ,month, week.

I have data from jan 2018

 I need one more column called weekmonth in the master calender like below.

1 Jan

8 Jan

15 Jan

22 Jan

29 Jan

5 Feb

12 Feb

19 Feb

26 Feb

5 Mar

12 Mar

19 Mar

26 Mar

2 Apr

9 Apr

 how to get the column like above

Please find the master calender  below

[StarinieriG]

Hi

 try with

Date(date,'D MMM')

[ramasaisaksoft]

Hi,

hope you are expecting DateMonth column so  Date

1 Jan

8 Jan

15 Jan

22 Jan

29 Jan

5 Feb

12 Feb

19 Feb

26 Feb

5 Mar

12 Mar

19 Mar

26 Mar

2 Apr

9 Apr

[Victor_Alumanah]

You could link this spreadsheet to your data 🙂

[tresesco]

Try like:

If(Mod(DayNumberOfYear(Date),7)=1, Date)  as  WeekMonth

[Victor_Alumanah]

you can load this code into your calendar script 

Day(WeekStart(DATE))&' '& Month(WeekStart(DATE)) as weekmonth

[Brett_Bleess]

If any of the existing posts helped you get a working solution, do not forget to use the Accept as Solution button to mark those that were helpful to let others know what worked and to give credit for the help provided.  

I am including a link to a Design Blog post that covers the Master Calendar, but there are some other calendar related posts in this area too, so I am going to paste the base URL after that, so you can search yourself if you want to look to see what else is out there that might be helpful.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett