Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
try with
Date(date,'D MMM')
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 |
You could link this spreadsheet to your data 🙂
Try like:
If(Mod(DayNumberOfYear(Date),7)=1, Date) as WeekMonth
you can load this code into your calendar script
Day(WeekStart(DATE))&' '& Month(WeekStart(DATE)) as weekmonth
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