Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
i'm trying to maintain a file for variable in Qliksense , but when i run this script .
i get this error
Temp_Variables:
LOAD Name,
Expression,
Comment
FROM [lib/expressions1.xlsx]
(ooxml, embedded labels, table is Sheet2);
// Create variables
for i = 0 to NoOfRows('Temp_Variables') - 1
let vName = peek('Name', i, 'Temp_Variables'); // Name of the variable
let vComment = peek('Comment', i, 'Temp_Variables'); // Comment/description of the variable
let $(vName) = peek('Expression', i, 'Temp_Variables') & chr(10) & '/* $(vComment) */'; // Expression
next i
// Remove temp variables
let i = null();
let vName = null();
let vComment = null();
// Remove temp tables
drop table Temp_Variables;
any idea please
The values for Name must be unique words.