Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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