Canonical Date Used Date Bridge

Tue, 13 Jun 2017 03:12:13 GMT

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;

Re: Canonical Date Used Date Bridge

Abhishekb — Wed, 23 Aug 2023 10:04:49 GMT

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

topic Canonical Date Used Date Bridge in App Development

Canonical Date Used Date Bridge

Re: Canonical Date Used Date Bridge