i) From 1 to 3 Years before
ii) From 1 to 3 Quarters before
iii) From 1 to 11 Months before
e) For Week
i) From 1 to 3 Years before
ii) From 1 to 26 Weeks before
f) For Date
i) From 1 to 3 Years before
ii) From 1 to 3 Quarters before
iii) From 1 to 11 Months before
iv) From 1 to 26 Weeks before
v) From 1 to 30 Days before
7. It might have more than required calendar information and that can be filtered. It will be demonstrated how to do.
Step by Step Guide
In Qlik SaaS, create a new application or use the application that you would like to use the Analytical Calendar. And then go to Data Load Editor to begin.
1. Click "Create New Connection".
2. Click "Google Drive".
3. Click "Authenticate".
4. Enter the Gmail account.
5. Enter the password.
6. Click "Continue".
7. Click "Allow".
8. Click "Copy to Clipboard".
9. Paste the link and click "Verify".
10. Update the Name and click "Test Connection".
11. Click "Close".
12. Click "Create".
13. Click the folder icon under the newly created connection.
14. Select the Analytical Calendar file and click "Select".
15. Wait.
16. Do the same for Date Range Linked Table. Select the file and click "Select". 
17. Do the same for Date Dimension. Select the file and click "Select".
18. Modify the script.
a) Add the Table Name.
b) In ANALYTICAL_CALENDAR, add the where clause
Where left([Unique Date], 4) >= 'YYYY' (YYYY is between 2015 to 2024)
c) In DATE_RANGE_LINKED_TABLE, add the where clause
Where exists(%DATE_RANGE_KEY)
and [%DATE_KEY] >= 'YYYY-MM-DD' (YYYY-MM-DD is between 2015-01-01 to 2024-12-31)
d) In DATE_DIMENSION, add the where clause
Where exists(%DATE_KEY)
All these will eliminate the unnecessary data.
19. Click "Load Data".
20. Enjoy using the Analytical Calendar !!
Conclusion
It is a no cost sharing. Very Simple and can let you enjoy the advantages of the Analytical Calendar. The settings are default and definitely can be customized for specific usage. If there is a demand, it would later enhance the overall distribution method to really help contribute to the Analytics realm. For the time being, have a try and let me know if you have any feedback. The calendar has been developing for quite some time and keep evolving based on the your comments.
Thank you!! I hope you enjoy the reading and sharing.
.png)
