Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Re: How to link master calendar

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;

Life is so rich, and we need to respect to the life !!!
Highlighted
pradosh_thakur
Valued Contributor III

Re: How to link master calendar

Re: How to link master calendar

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

http://masterssummit.com

http://qlikviewcookbook.com

Community Browser