Discussion board where members can get started with QlikView.
First i need to create master calendar.
i have 3 tables with date fields and 3 dates fields different dates available.so how map the master calendar into this dates fields.
Load Date1 as DateField, 'Date1' as Flag From T1;
Load Date2 as DateField, 'Date2' as Flag From T2;
Load Date3 as DateField, 'Date3' as Flag From T3;
Load DateField, Week(DateField) as Week, ....;
Load Date(MinDate + IterNo() - 1) as DateField
While Date(MinDate + IterNo() - 1) <= MaxDate;
Load Min(DateField) as MinDate,
Max(DateField) as MaxDate
I think you need The Fastest Dynamic Calendar Script (Ever)