topic Re: set a variable in QlikView

set a variable

adiarnon — Wed, 25 Nov 2020 16:16:04 GMT

hi,
i want to set a variable in the script that have-
if($(v_metric_5)<90,'red',if($(v_metric_5)<95,'yellow',if($(v_metric_5)<=100,'green','gray')))

how can i do that?

i dont want that $(v_metric_5) will calculate

i want it to stay as a string

adi

Re: set a variable

Anil_Babu_Samineni — Mon, 29 Oct 2018 08:56:03 GMT

Not sure, what do you mean by string? May be this

if('$(v_metric_5)'<90,'red',if('$(v_metric_5)'<95,'yellow',if('$(v_metric_5)'<=100,'green','gray')))

How you have created this variable v_metric_5

Re: set a variable

vishalgoud — Mon, 29 Oct 2018 10:43:42 GMT

yes what is that v_metric_5 ??

is it is a variable ?? if varible then it will take the values as per the variable value.

if it is field then you no need to consider it as string or any other format...

Re: set a variable

MindaugasBacius — Mon, 29 Oct 2018 11:12:36 GMT

adiarnon

Here is the difference between setting the variables:

SET vVariable = 1 + 2; //Value returned 1 + 2

LET vVariable = 1 + 2; //Value returned 3

See the attachment that might be helpful.

Re: set a variable

rwunderlich — Mon, 29 Oct 2018 11:43:23 GMT

Dollar Sign Expansion (DSE) always occurs in script, which is generally a blessing but sometimes a curse. One workaround is to use a proxy character for the $ and then replace(). For example:

LET v1 = replace(

'if(@(v_metric_5)<90,''red'',if(@(v_metric_5)<95,''yellow'',if(@(v_metric_5)<=100,''green'',''gray'')))'

,'@','$');

You will need to double up your single quotes to allow them within the LET string.

Another approach is to use a proxy char for both $ and ' replacing both with a mapsubstring:

EscapeCharsMap:

MAPPING LOAD * INLINE [

from, to

@,$

|,'

];

LET v2 = MapSubString('EscapeCharsMap',

);

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com