topic Re: Doubt about calendar, link table, and dates. in QlikView

Doubt about calendar, link table, and dates.

Fri, 16 Jan 2015 16:10:17 GMT

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 — Fri, 16 Jan 2015 16:19:44 GMT

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

rwunderlich — Fri, 16 Jan 2015 18:27:18 GMT

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

and

-Rob

MarcoWedel — Mon, 19 Jan 2015 20:41:24 GMT

please post sample data/app.

regards

Marco

Tue, 20 Jan 2015 13:54:27 GMT

Ok i'll post an sample app

jmmayoral3 — Tue, 20 Jan 2015 14:01:22 GMT

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.

Tue, 20 Jan 2015 14:16:29 GMT

Tue, 20 Jan 2015 14:16:46 GMT

Here an example

thanks