Doubt about calendar, link table, and dates.

[#1]

Hi everybody.

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

etc...

But i don't know what date use with the calendar. Should i concatenate all the dates or what?

Thank you!

[vinafidalgo]

Try using AutoGenerate getting the max date and min date, it should solve your problem.

[rwunderlich]

You will want to establish a common date field for all your dates. See

Canonical Date

and

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

[MarcoWedel]

please post sample data/app.

regards

Marco

[#5]

Ok i'll post an sample app

[jmmayoral3]

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.

[#7]

http://community.qlik.com/message/698079#698079

[#8]

Here an example

thanks

http://community.qlik.com/message/698079#698079