1 Reply Latest reply: Jan 15, 2018 1:21 PM by Sunny Talwar RSS

    data appear as a date instead of number

    Caroline Huet

      Hello,

       

      I have a pivot table that I imported in QlikSense, I used the "crosstable" function to transform data and the data in the new column appears in a date format instead of general format. I would like to have a column "DateCadence" which will be represented by dates and a column "cadence" that will be numbers.

       

      The code used is written below

       

      tabCadence:

       

      CrossTable (DateCadence,Cadence , 4) load *;

       

      LOAD *

       

      FROM [lib://Qlik Essai1/cadences_test.xlsx]

      (ooxml, embedded labels, table is Feuil1);

       

      NoConcatenate

       

      load  Programme,

       

          Client,

         

          Code,

         

          DateCadence,

         

          num#(Cadence) as Cadence;

       

      LOAD * Resident tabCadence;

       

      Drop table tabCadence;

       

      Thanks