Technical Discussion | Analytical Calendar The Story | The Index Page
Analytical Calendar
Thanks for following up all the posts. I am eventually confident to release the code for public use. Please leave your feedback and use it happily and evolve analytics. The code is for Qlik to make best of the usage of associative data model to maximise the usage of the analytical calendar.
How to Configure the Analytical Calendar
First, you can customise the code by yourself but make sure you understand well before doing so. The easiest way is to import the analytical_calendar.qvs into the Qlik script and start the configuration. What it needs two major steps:
1. Change the parameter.
vStartDate
It is the start date of the calendar.
vEndDate
It is the end date of the calendar.
vMaxYRolling
It is the maximum rolling years.
vMaxQRolling
It is the maximum rolling year quarters.
vMaxMRolling
It is the maximum rolling year months.
vMaxWRolling
It is the maximum rolling year weeks.
vMaxDRolling
It is the maximum rolling days.
vMaxYComparison
It is the maximum comparison year range.
vMaxQComparison
It is the maximum comparison year quarter range.
vMaxMComparison
It is the maximum comparison year month range.
vMaxWComparison
It is the maximum comparison year week range.
vMaxDComparison
It is the maximum comparison date range.
2. To pick one of the week usage, either Incomplete Week (Broken Week) or Complete Week (Unbroken Week).
Just remove the one that you do not want to use.
Associate to the Analytical Calendar and How to Write the Expression
Just load them into your dashboard and make sure you have a fact table with %DATE_KEY to associate to the analytical calendar.
In general, you will just need two similar expressions:
1. analysis period, sum({<[Comparison Perspective]={'N/A'}>} Exp1)
2. comparison period, sum(Exp1)
I keep this one very short. In case if you have any questions, feel free to jot me a note.
Same details, you can find in my github. Thank you!
No comments:
Post a Comment