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
date(num#(purgeChar(Months,'"'),'00000')) as Months
Drop table Capacity;
View solution in original post
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
I have a similar requirement where date format is Jun-19, jul-19
But i am not able to see the data after loading.
Please help me with this issue