https://community.qlik.com/t5/QlikView/If-statement-determined-by-varaible-value/m-p/1555106#M440627 <P>Hi, I am trying to set a rule to highlight the text box depends on the variable value</P><P>Below are my draft script:</P><P>if(vOn='Y',rgb(0,255,0),rgb(255,255,255)</P><P>value for vOn: 'Y'</P><P>It appears that always 'else' expression is shown (white background)</P><P>The statement seems to be worked when I change the value of vOn to Y instead of 'Y'. I think it should be quotation problem. But what should I do to my script if I really want to use 'Y' as the variable value.</P><P>Prior thanks.</P> Sat, 16 Nov 2024 21:16:03 GMT Sky_qlik 2024-11-16T21:16:03Z https://community.qlik.com/t5/QlikView/If-statement-determined-by-varaible-value/m-p/1555106#M440627 <P>Hi, I am trying to set a rule to highlight the text box depends on the variable value</P><P>Below are my draft script:</P><P>if(vOn='Y',rgb(0,255,0),rgb(255,255,255)</P><P>value for vOn: 'Y'</P><P>It appears that always 'else' expression is shown (white background)</P><P>The statement seems to be worked when I change the value of vOn to Y instead of 'Y'. I think it should be quotation problem. But what should I do to my script if I really want to use 'Y' as the variable value.</P><P>Prior thanks.</P> Sat, 16 Nov 2024 21:16:03 GMT https://community.qlik.com/t5/QlikView/If-statement-determined-by-varaible-value/m-p/1555106#M440627 Sky_qlik 2024-11-16T21:16:03Z https://community.qlik.com/t5/QlikView/If-statement-determined-by-varaible-value/m-p/1555111#M440628 <P>Use pairs of single quotes to embed them in the condition:</P><PRE>=if(vOn = '''Y''', rgb(0,255,0), rgb(255,255,255)</PRE> Tue, 12 Mar 2019 04:52:05 GMT https://community.qlik.com/t5/QlikView/If-statement-determined-by-varaible-value/m-p/1555111#M440628 jonathandienst 2019-03-12T04:52:05Z