Discussion board where members can get started with QlikView.
I have doubts about creating a calendary and the link table
I have 3 or 4 fact tables, and more dimension tables, and i have a lot of dates like "end of transaction date" "check date" etc
And i have a LT with the ids and etc.. its working fine.
Now i have to create a graphic divided with Year-Month.
And now i think that i should create a calendary with something like this
date as date
year(date) as Year
But i don't know what date use with the calendar. Should i concatenate all the dates or what?
Try using AutoGenerate getting the max date and min date, it should solve your problem.
You will want to establish a common date field for all your dates. See
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
please post sample data/app.
Ok i'll post an sample app
No. You don´t must concatenate dates.
You have to find a master date field. A date that covers all data that you want to analyze.
Then create a Canonical Calendar and use the rest of dates like secondary dates to analyze data.
Here an example