0 Replies Latest reply: Jun 12, 2017 11:12 PM by MK DA RSS

    Canonical Date Used Date Bridge

    MK DA

      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;