Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Linking to two or more dates

cancel
Showing results for 
Search instead for 
Did you mean: 
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Linking to two or more dates

Last Update:

Feb 7, 2014 2:44:13 PM

Updated By:

rwunderlich

Created date:

Feb 7, 2014 2:44:13 PM

Attachments

This tutorial presents a script pattern for assigning time dimensions to multiple fact dates in a data model. It answers the commonly asked Forum question "how do I link to two dates"?

The pattern will demonstrate how to link all fact dates to a common calendar as well as using separate calendars for each fact date.

Labels (2)
Comments
vadim_grab
Creator
Creator

rwunderlich‌ Rob, sorry for my lively non topic  discussion with ahaahaaha on your page. Thanks a lot for your advise!

0 Likes
luismadriz
Specialist
Specialist

Hi Rob, any chance you can share this for QlikSense?

Many thanks,

Luis

0 Likes
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Luis,

You can download a Qlik Sense version here:

Search Recipes | Qlikview Cookbook

luismadriz
Specialist
Specialist

Awesome,

Last week I published a document on a process to create MasterCalendars from a date field on a fact table to deal with time measures such as Calendar / Financial / Season and Current / Previous / YTD / Etc.

My 2 cents on Time Analysis

I wish I had seen your process before. It's great!!!!

Many thanks,

Qlik rocks!

Luis

mjtaft2017
Partner - Creator
Partner - Creator

Thanks for the Qlik Sense version as I couldn't get past the license issue on the Qlikview version.  One question I had - do I always need to use this type of solution if I have more than 1 date field or only under certain circumstances.  In my situation I have a product that has a built and sold date.  I didn't really think I needed multiple fact tables since there is only 1 product and it has a unique product ID.

0 Likes
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This type of solution -- a common calendar -- is only required when you want the user to be able to select a single time value (e.g. Month) and have that selection represent multiple date fields (e.g. BuiltDate and SoldDate).

0 Likes
overclocked
Contributor II
Contributor II

Thanks Rob this helped me a lot

0 Likes
612118513
Contributor II
Contributor II

Thanks a lot @rwunderlich take me almost a month to solve one issue combining dates, but now is clear with your great help and example.

I just need a small help, is posible to create the  Common Calendar as Fiscal Calendar? my idea is to have fiscal year, Fiscal quarter, fiscal Month created by this calendar, is that posible?

 

Thanks in advance for your great help.

BR

0 Likes
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can certainly make the common calendar a fiscal calendar.  The linking field is normally a Date.  You can assign whatever Year or other attribute is correct for your calendar. 

-Rob

0 Likes
ritaaguiar
Creator
Creator

Hi,

How can I open this file? I get an error saying that 'the licence that is embedded in this document is not valid'.

Thanks.

0 Likes
Version history
Last update:
‎2014-02-07 02:44 PM
Updated by: