Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Help with a crosstable and dates

Hello,
I'm trying to load some data using crosstable and its half working but I can't seem to change the field from a numeric to a date?  Any ideas?

The datasource is an excel spreadsheet with the columns being dates?

[Sheet1]:
CrossTable(YearMonth,Sheet1)
LOAD
[CHANNEL]&[PERIL]&[Capped / XS]&[Measure] AS [Metric],
[42370],
[42401],
[42430],
[42461],
[42491],
[42522],

Labels (2)
5 Replies
anushree1
Specialist II
Specialist II

can you please share the sample file

bazzaonline
Creator
Creator
Author

Hello,  This is how the data looks in Excel, its the first row of dates that convert to a numberic but I want to keep as a date.

CHANNELPERILCURRENT MONTH PROJ'N SELECTIONCapped / XSMonths for Projn calcMeasureJan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Oct-16Nov-16Dec-16
Channel ARain201705(All)12Measure 1            
Channel ARain201705(All)12Measure 2            
Channel ARain201705(All)12Measure 3666869576548597461667056
Channel ARain201705(All)12Measure 4666869576548597461667056
Channel ARain201705(All)12Measure 5444737313330384036384340
Channel ARain201705(All)12Measure 6444737313330384036384340
anushree1
Specialist II
Specialist II

I see it appearing as date .

Please check the attached

bazzaonline
Creator
Creator
Author

Sorry I can't access the file?  Probably as on a limited version of Qlik Sense, can you paste the script as a message?

Julio2022
Contributor
Contributor

I'm facing the same doubt... I would keep the first row such as date , like is typed at the excel file ...  

After the cross table QV convert to text , for example:  Mayt,31 2022 is showing  [44742.000000]