Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date from different tables

Hi,

I've created a master calendar in my set analysis. I've got few tables with different types of data (i.e. budgeted, realised etc.) but they all have date dimension.  I would like to have them all connected to the master calendar. Is this correct and the best solution to that, that I add to Master Calendar a separate row with date to connect invidually to the tables?

I mean if in tables (Orders, WorkTime, Wages) I've got column named YearMonth (YYYYMM), I need to rename them so that they would be different like YearMonthOrd - for orders, YearMonthWT, YearMonthW and then add the same row to master calendar like it's shown below?

I would like to avoid creating new dimensions and have in master calendar only one universal value YearMonth

MasterCalendar:

Load

  TempDate AS DocumentDate,

  Year(TempDate)&  Num(Month(TempDate),'00') AS YearMonthOrd,

  Year(TempDate)&  Num(Month(TempDate),'00') AS YearMonthWT,

  Year(TempDate)&  Num(Month(TempDate),'00') AS YearMonthW,

  week(TempDate) As Tydzien,

  Year(TempDate) As Rok,

  Year(TempDate)&  Num(Month(TempDate),'00')  AS YearMonth,

  Month(TempDate) As Miesiac,

  Day(TempDate) As Dzien,

10 Replies
Anonymous
Not applicable
Author

I've analysied my problem once again and invented the solution which I described

Circular reference caused by canonical date