Variable name as a field name: works in Qlik View but not in Sense
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!
