Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
can you please share the sample file
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.
CHANNEL | PERIL | CURRENT MONTH PROJ'N SELECTION | Capped / XS | Months for Projn calc | Measure | Jan-16 | Feb-16 | Mar-16 | Apr-16 | May-16 | Jun-16 | Jul-16 | Aug-16 | Sep-16 | Oct-16 | Nov-16 | Dec-16 |
Channel A | Rain | 201705 | (All) | 12 | Measure 1 | ||||||||||||
Channel A | Rain | 201705 | (All) | 12 | Measure 2 | ||||||||||||
Channel A | Rain | 201705 | (All) | 12 | Measure 3 | 66 | 68 | 69 | 57 | 65 | 48 | 59 | 74 | 61 | 66 | 70 | 56 |
Channel A | Rain | 201705 | (All) | 12 | Measure 4 | 66 | 68 | 69 | 57 | 65 | 48 | 59 | 74 | 61 | 66 | 70 | 56 |
Channel A | Rain | 201705 | (All) | 12 | Measure 5 | 44 | 47 | 37 | 31 | 33 | 30 | 38 | 40 | 36 | 38 | 43 | 40 |
Channel A | Rain | 201705 | (All) | 12 | Measure 6 | 44 | 47 | 37 | 31 | 33 | 30 | 38 | 40 | 36 | 38 | 43 | 40 |
I see it appearing as date .
Please check the attached
Sorry I can't access the file? Probably as on a limited version of Qlik Sense, can you paste the script as a message?
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]