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
CrossTable (DateCadence,Cadence , 4) load *;
FROM [lib://Qlik Essai1/cadences_test.xlsx]
(ooxml, embedded labels, table is Feuil1);
num#(Cadence) as Cadence;
LOAD * Resident tabCadence;
Drop table tabCadence;