Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

set a variable

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?

3 Replies
petter
MVP
MVP

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

rubenmarin

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(

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

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

dsharmaqv
Creator III
Creator III

try this

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