Qlik Community

Qlik Sense App Development

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

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;

Community Browser