topic Re: Qliksense variable file in App Development

Qliksense variable file

yogitamehta10 — Thu, 23 May 2019 15:15:09 GMT

Hi ALL,

i'm trying to maintain a file for variable in Qliksense , but when i run this script .

i get this error

The following error occurred:

Unexpected token: 'Rate', expected: '='

The error occurred here:

let vFormConversion >>>>>>Rate<<<<<< = peek('Expression', i, 'Temp_Variables') & chr(10) & '/* NA */'

SCript i'm Using

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

TIA

Re: Qliksense variable file

jensmunnichs — Thu, 23 May 2019 15:27:31 GMT

Seems to me like your list of names has a value with a space in it, which would break the LET statement.

EDIT: The value being 'vFormConversion Rate', if that wasn't clear.

Re: Qliksense variable file

yogitamehta10 — Thu, 23 May 2019 15:42:06 GMT

Thanks ..

Re: Qliksense variable file

rwunderlich — Thu, 23 May 2019 18:17:21 GMT

You generally shouldn't have spaces in your variable names, but you can tolerate it by adding brackets around the variable name in the script:

let [$(vName)] = peek('Expression', i, 'Temp_Variables') & chr(10) & '/* $(vComment) */'; // Expression

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com