Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Canonical Date Used Date Bridge

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;