topic scripting question assign variable in QlikView

scripting question assign variable

Wed, 26 Mar 2014 10:16:05 GMT

Hi all,

I have the following:

a variable defined in the script: set vLanguage '=Language';

a variable vProduct defined with the menu options 'settings varaibale overview' =chr(91)&'Product' &chr(95) & '$(vLanguage)' & chr(93)

This all works works fine and gives me the result I am looking for.

However I am curious how to add the variable vProduct in the script.

set vLanguage = '=Language';

set vProduct = =chr(91)&'Product' &chr(95) & '$(vLanguage)' & chr(93);

The result here is in the variable vProduct: =chr(91)&'Product' &chr(95) & '=Language' & chr(93)

My question is: How to write the script in such a way that the variable vProduct is equal to : =chr(91)&'Product' &chr(95) & '$(vLanguage)' & chr(93)

Thanks in advance,

Gerrit

alexandros17 — Wed, 26 Mar 2014 10:32:15 GMT

Try with

LET vProduct = chr(91)&'Product' &chr(95) & '$(vLanguage)' & chr(93);

daveamz — Wed, 26 Mar 2014 10:36:25 GMT

Hi,

LET vProduct = '=chr(91)&'&chr(39)&'Product' & chr(39) & ' & chr(95) & '& chr(39)& CHR(36) &'(vLanguage)' & chr(39) & ' & chr(93)';

Regards,

David

Wed, 26 Mar 2014 10:48:31 GMT

The result here is: [Product_=Language]

Unfortunaltely not the outcome I am looking for.

Thanks

ThornOfCrowns — Wed, 26 Mar 2014 10:56:36 GMT

As an aside;

Set: Assigns the value (or expression which is after the equal sign) as it is without compututation.

Let: Calculates the expression assigned to it and sets the expression result to the variable.

Example:

Set vMyVar=2+3;

vMyVar has the expression 2+3 as value we have to compute it using $(vMyVar) which returns 5

Let vMyVar=2+3;

vMyVar has the computed value 5

Wed, 26 Mar 2014 11:30:17 GMT

David,

Your solution works fine.

It's still a bit hard to understand what exactly is happening but I am working on that .

Thank you very much.

Gerrit