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.

[neerajce]

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

[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?

[thatmemo]

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

[steveoshaughnessy]

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.