Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Doubt about calendar, link table, and dates.

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!

7 Replies
Highlighted
Creator
Creator

Re: Doubt about calendar, link table, and dates.

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Doubt about calendar, link table, and dates.

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

Highlighted

Re: Doubt about calendar, link table, and dates.

please post sample data/app.

regards

Marco

Highlighted
Not applicable

Re: Doubt about calendar, link table, and dates.

Ok i'll post an sample app

Highlighted
Creator
Creator

Re: Doubt about calendar, link table, and dates.

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.

Highlighted
Not applicable

Re: Doubt about calendar, link table, and dates.

Highlighted
Not applicable

Re: Doubt about calendar, link table, and dates.