Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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