Creating and understanding the Master Calendar - Qlik Sense

[@HearthBorn]

Great concept! I'll be playing with this code soon and see how it works when a single master calendar table is joined to multiple date fields.

[@nobomopo]

Good stuff! :)

[@NaraTunes]

thanks a lot! very helpful

[@neerajce]

How can I add Fiscal Year, Fiscal Quarter in this same calendar

[@QlikOfficial]

Hello Neeraj - thanks for your question - check this out - community.qlik.com/t5/Qlik-Design-Blog/Fiscal-Year/ba-p/1472103 - if this does not help - please open a new discussion thread in the Qlik Community forums.

[@waterbitten]

this was really helpful. thank you!

[@GuyInaQ]

Great to hear - come join us in the Qlik Community as well - community.qlik.com

[@TimJeanes]

I have implemented this and it works as shown in the video. However, as soon as I introduce any other filter, it goes back to the old behaviour of missing dates on the chart's x-axis. How can I avoid this?

[@QlikOfficial]

+Tim Jeanes Hi Tim - please join the Qlik Community to work with our team and other community members kzbin.info/www/bejne/sJipZmqCnNx4h6M

[@davidarroyo1487]

Hello +Tim. i have the same problem that you described in your commet. Did you fix it?

[@TimJeanes]

David Arroyo I really can't remember, sorry.

[@anilkumarrai6913]

Good info..

[@eduardofernandez4011]

Very useful

[@yanamadalaharishkumar5041]

how to perform YTD,MTD ????

[@1davidbe]

Can you Upload the script txt ?

[@QlikOfficial]

+David Benshimol Hi David it is available here: community.qlik.com/docs/DOC-8642

[@thatmemo1983]

Very useful video, but what if we have more than one date field do we have to create new section for every date field or we can use the same section? for example i have a table regarding sales with invoice date and payment date, thanks in advance

[@GuyInaQ]

Hi Mohamad you can use the same section. Join us in the Qlik Community for support related questions. community.qlik.com

[@steveoshaughnessy3736]

Thanks! I didn't realize the range selection features. That will help me a lot. Two complaints though. There is no X is eTcetera. My other big complaint about Qlik is your non-standard use of table names. Table names are not pluralized. I noticed you have a mix. While it's true we are often talking about sets of data, the set name its self is not plural. It's Order.OrderID, not Orders.OrderId. It's the ID of the (each) order. There is only one per order. While we might rename the Order table to A (also, poor form, but for example), we would never call it As. Why is plural ok in one instance but not the other. The answer is because it's actually NOT ok in one instance. Another issue is the inconsistent pluralization of English words. If it's not ok in every case (e.g., As) it's probably not ok anytime. Table names are singular.