This content has been marked as final. Show 7 replies
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.