topic Re: master Calender in QlikView

master Calender

qlikapple — Sat, 16 Nov 2024 02:14:57 GMT

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

Re: master Calender

StarinieriG — Fri, 11 Oct 2019 07:47:25 GMT

try with

Date(date,'D MMM')

Re: master Calender

ramasaisaksoft — Fri, 11 Oct 2019 07:52:38 GMT

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

Re: master Calender

Victor_Alumanah — Fri, 11 Oct 2019 08:39:41 GMT

You could link this spreadsheet to your data 🙂

Re: master Calender

tresB — Fri, 11 Oct 2019 08:50:11 GMT

Try like:

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

Re: master Calender

Victor_Alumanah — Fri, 11 Oct 2019 09:12:53 GMT

you can load this code into your calendar script

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

Re: master Calender

Brett_Bleess — Tue, 15 Oct 2019 18:22:48 GMT

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