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.
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?
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
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.
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.
Good stuff! :)
thanks a lot! very helpful
this was really helpful. thank you!
Great to hear - come join us in the Qlik Community as well - community.qlik.com
How can I add Fiscal Year, Fiscal Quarter in this same calendar
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.
Good info..
Very useful
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?
+Tim Jeanes Hi Tim - please join the Qlik Community to work with our team and other community members th-cam.com/video/zgF57LgwEQA/w-d-xo.html
Hello +Tim. i have the same problem that you described in your commet. Did you fix it?
David Arroyo I really can't remember, sorry.
how to perform YTD,MTD ????
Can you Upload the script txt ?
+David Benshimol Hi David it is available here: community.qlik.com/docs/DOC-8642
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
Hi Mohamad you can use the same section. Join us in the Qlik Community for support related questions. community.qlik.com
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.