Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Every time when i start work on QV project i get this issue of linking my Master Calendar with dates available in multiple tables.
This time i need to understand it correctly.
I have date field in 3 different tables and I have a Master calendar. I need to link date fields from 3 tables with Master Calendar date field.
Appreciate any guidance on this and explanation.
Thanks,
Poonam
There is no way to split from single table. But could be work using multi loads like
Fact:
LOAD Date1 as DateField, 'Date1' as Flag, Sales FROM Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
Date2:
LOAD Date2 as DateField, 'Date2' as Flag, Sales FROM Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
Date3:
LOAD Date3 as DateField, 'Date3' as Flag, Sales FROM Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
CalendarMaster:
LOAD Date(DateField) AS Date,
Load Date(MinDate + IterNo() -1) AS Date While (MinDate + IterNo() - 1) <= Num(MaxDate);
Load Min(DateField) AS MinDate, Max(DateField) AS MaxDate RESIDENT Fact;
https://community.qlik.com/blogs/qlikviewdesignblog/2012/08/30/master-table-with-multiple-roles
Does this help ? HIC got a solution for you here i guess.
Yes, as Anil suggested, load each date in a separate load statement. There should be no difference in the pattern whether the dates are in the same or different tables.
-Rob
Thank you rwunderlich!
Suggested solution worked.