Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

gkcchowdary
Contributor

how to create master calendar and map to the fields?

Hi

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.


Thanks

daisy

2 Replies

Re: how to create master calendar and map to the fields?

Perhaps this?


Table:

Load Date1 as DateField, 'Date1' as Flag From T1;

Concatenate

Load Date2 as DateField, 'Date2' as Flag From T2;

Concatenate

Load Date3 as DateField, 'Date3' as Flag From T3;


Calendar:

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

Resident Table;

Highlighted
juraj_misina
Valued Contributor

Re: how to create master calendar and map to the fields?

Hi,

I think you need The Fastest Dynamic Calendar Script (Ever)

Best

Juraj