Discussion board where members can get started with Qlik Sense.
I have a problem with crossTable Load. I have this table in Excel:
I use this code:
Name as WorkerName,
(ooxml,embedded labels, table is Sheet1);
I need to view dates, but when I try to convert it to date, no results (Date, Timestamp...)
How to load this data? Especially for a heatmap?
Thaks a much for your ideas
Go to Solution.
date(num#(purgeChar(Months,'"'),'00000')) as Months
Drop table Capacity;
Thank you very much
Thank you so much for this. I will never get the last four hours of my life back but I won't waste the next four. This is wonderful