Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am loading data from Excels that have a format:
8888 - Name Surname | 06/01/2020 | 13/01/2020 | 20/01/2020 | 27/01/2020 | 03/02/2020 | 10/02/2020 | 17/02/2020 |
I have created and tested code in Qlik View (because I transform the excel data and it is easier in View); works fine. Now, when I try to use same code in Sense, it is not able to load this field's '8888 - Name Surname' (variable VName) and read the data from excel.
LET VName = '8888 - Name Surname';
Num("$(VName)", '##0', '.' , ',' ) as Date,
Final purpose is to have dates in correct format DD.MM.YYYY. I have tried the following:
"$(VName)" as Date,
//Num#("$(VName)",'0.0') as Date,
//Num("$(VName)", '##0', '.' , ',' ) as Date,
//date(("$(VName)"),DD.MM.YYYY') as Date,
//date(Num("$(VName)", '##0', '.' , ',' ),DD.MM.YYYY') as Date,
Does anyone see what is wrong? Or know what is the difference between View and Sense, why it works in View but not in Sense?
Edit:
I found errors from source files. Now this works fine!
Kind regards, AdoumaK