Canonical Date Used Date Bridge

[#1]

Hi Friends,

I have been able to create a canonical date used script date bridge below, but when I applied to the chart the result was incorrect.

What should I do ? What was wrong with my script ?

Thanks for your help.

/Mikada

[Sales]:

LOAD [Sales Date],

[Branch],

    [Qty]

FROM [lib://Qlik Data/Test.xlsx]

(ooxml, embedded labels, table is Sales);

[MP]:

LOAD [MP Date],

[Branch],

    [HC]

FROM [lib://Qlik Data/Test.xlsx]

(ooxml, embedded labels, table is MP);

DateBridge:

LOAD [Branch], [Sales Date] as CanonicalDate, ('SalesDate') as DateType

RESIDENT Sales;

LOAD [Branch],[MP Date] as CanonicalDate, ('MPDate') as DateType

RESIDENT MP;

[Abhishekb]

You are going correct but further again you have to create master calendar and use that date. I think the below link will help you for completing your solution.

Canonical Date in Qlik (handling multiple dates in Fact table) - YouTube