Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
LOAD [Sales Date],
FROM [lib://Qlik Data/Test.xlsx]
(ooxml, embedded labels, table is Sales);
LOAD [MP Date],
(ooxml, embedded labels, table is MP);
LOAD [Branch], [Sales Date] as CanonicalDate, ('SalesDate') as DateType
LOAD [Branch],[MP Date] as CanonicalDate, ('MPDate') as DateType