data appear as a date instead of number

[Anonymous]

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

[sunny_talwar]

Look at the responses here:

Data appears in date format instead of number format after crosstable transformation