QlikSense Tutorial - How to create a master Calendar from Dates in Qlik Sense

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@GracefulTalesPluto]

@ 1:34 you said you have the master calendar script we can use it for our apps, where is it? I can't find it on the links you gave in the description box

[@padmininagarajan5250]

Hey, Super explanations on QlikSense topics, I am learning a lot. Thank you!! Can you please make sure the screens are zoomed in so we can read properly. Appreciate it.

[@thinkmetrics]

Thanks a lot. Thanks for the feedback. Will improve it. 👍🏻

[@mohamedsuhail5985]

Hi it was a nice one, is that script sheet is the paid one?

[@thinkmetrics]

No

[@ramandeepsr]

Master Calendar Script is not there in the links provided.

[@thinkmetrics]

It’s there

[@MattBellamy881]

Another really helpfull tutorial, thank you! One question, are we sure it is enough to create a master calendar to fullfill all the 0 values from sales? Let's take example I have a fact table that go deeply in detail from Customer, product category, subcategories etc until a single code at maximum detail. If I just add a master calendar linked to the Fact table (in which there is the order date) automatically I can see the not-sales on a chart or a table? If it's so, then it's superb... I thought I had to generate a script that fullfill every single case.... Waiting for a feedback from you or who else know it! Thanks!

[@thinkmetrics]

Thanks 🙏 You're right. Having a master calendar won't give you zero values in your fact. You would need to insert that by yourself. But the master calendar will give you the missing dates so you ll be able to select it at least.

[@khimabindu6374]

Hi, I'm just a beginner to this course, I need some suggestions can you plz plz help me

[@seenivasanbaskar1798]

Hi Kaush, This video is simply superb and helps beginners like me. Could you please share the script? I did not see any link to download

[@thinkmetrics]

Hi, It's in the Qlik File: kaush.gumroad.com/l/ZASsB

[@PS-vc6ef]

Where is the link to the file? I am not able to find the file that I can use to practice while watching your video! The link provided only shows dashboard pictures.

[@thinkmetrics]

There's a 'I want this file' button on the side. Hope it helps. Otherwise let me know and I'll send you the file. Thanks !

[@furkankk10]

Hey, big thanks. i have a problem my orders date with timestamps. i used date function orders date for orders table and master calender associate. but not working. master calendar date show null date :( what should i do ?

[@thinkmetrics]

Yes, you ll need to do a date(floor(order date))

[@saravana5720]

Thanks a lot for your knowledge sharing..It helps a lot.

[@thinkmetrics]

You're welcome😊

[@MrRoots974]

hey mate, big thanks ! take care

[@thinkmetrics]

Thanks 🙏

[@Joker.of.All.Trades]

Was the script for the Qlik calendar removed?

[@thinkmetrics]

No

[@뚜스따스뚜]

This is really amazing video! Thank you:)

[@thinkmetrics]

Thank you! 😊

[@nataliaguartechea36]

Hi, can you share de link to the file? Thanks

[@thinkmetrics]

Its in the description 😊

[@cherianjohn8559]

Hi, Can you share the master calendar scripts pl.

[@thinkmetrics]

The link is in the description

[@cherianjohn8559]

@@thinkmetrics Many thanks for your response, I'm struggling to see the link, could you past the link here pl.

[@AA-kq8on]

thank you

[@thinkmetrics]

👍🏻

[@MananMehta-bh4gu]

Hi! While trying your script I am running in to the error Filed ' 44716' not found where we are loading TempCalender. Can you help why this error?

[@sanjanasandhiri7378]

@MananMehta-bh4gu I am getting the same error . Were you above to resolve your problem ?

[@ardyey25]

Can you share the calendar script pls? Thank you

[@thinkmetrics]

Hi. Link in the description. It's available in the app qvf file. 😊