topic set a variable in QlikView

set a variable

adiarnon — Mon, 29 Oct 2018 08:21:24 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?

Re: set a variable

petter — Mon, 29 Oct 2018 08:35:38 GMT

Please do not cross-post (post the exact same question multiple times) as it is counter-productive. Read the Community guidelines and do your best to follow them

Re: set a variable

rubenmarin — Mon, 29 Oct 2018 08:36:08 GMT

Hi adi, one way is using an alternative character for simple quotes and dollars, and use replace to reset to original characters, ie. using | as simple quote and # as dollar:

LET VarName =Replace(Replace(

,'|',Chr(39)), '#', '$');

Re: set a variable

dsharmaqv — Mon, 29 Oct 2018 08:36:13 GMT

try this

=IF(v_metric_5<00,Red(),IF(v_metric_5<9510,Green(),IF(v_metric_5<=100,Blue())))