this is my first post so try to be gentle .
I am new to qlik Sense and doesnt have any experience with qlik view so far.
My problem is that I cant convert a datetime serial number into a date again:
I am importing an excel file with a date format like 01.01.2106, it looks like qlik sense automaticly cast this format into his own
datetime serial format. After the load i transform the table into crosstable my table looks like this:
|42370||Some Random Text||10|
Now I tried to load the resident table with some a converted date.
My script looks like this:
Date(MonthName) as Date, // also tried Date(MonthName,'DD/MM/YYYY') as Date
Resident TempBudget ;
But im only getting a empty column.
I hope there is an easy way to do this.
Solved! Go to Solution.
Try a resident load after your CrossTable LOAD.
LOAD Date(Num#(MonthName, '##'), 'DD/MM/YYYY') as Date,
DROP Table TempBudget;
Also, in your post you mentioned datetime? Does your date contain time infor also? If it does, then try this:
Date(Floor(Num#(MonthName, '##')), 'DD/MM/YYYY') as Date,