Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

demaina1995
New Contributor II

data appear as a date instead of number

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

1 Reply

Re: data appear as a date instead of number

Community Browser