If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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],,,,,,,
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.
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]