topic Re: Compare a value in a variable in the script in QlikView https://community.qlik.com/t5/QlikView/Compare-a-value-in-a-variable-in-the-script/m-p/307085#M1180844 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P><STRONG><STRONG><STRONG><STRONG><STRONG>From sales&nbsp; where sales_account =$(VX)</STRONG></STRONG></STRONG></STRONG></STRONG></P></PRE></BODY></HTML> Wed, 25 Jan 2012 17:31:57 GMT 2012-01-25T17:31:57Z Compare a value in a variable in the script https://community.qlik.com/t5/QlikView/Compare-a-value-in-a-variable-in-the-script/m-p/307084#M1180843 <HTML><HEAD></HEAD><BODY><P>I have a variable VX , what is the syntax I have to use to compare in SQL script one field with the value of this variable?</P><P></P><P>I put here the example I have </P><P><STRONG></STRONG></P><P></P><SPAN style="color: #0000ff; font-size: 8pt;"> </SPAN><P></P><P>Load </P><P><STRONG> </STRONG></P><P><STRONG><STRONG>Sales_account </STRONG></STRONG></P><P><STRONG><STRONG><STRONG> </STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG>From sales&nbsp; where sales_account =&nbsp; variable , I want to know what is exactly the syntax for this comparison.</STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG> </STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG>Thanks,</STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG> </STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG><STRONG> </STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></STRONG></P><P></P></BODY></HTML> Wed, 25 Jan 2012 17:09:29 GMT https://community.qlik.com/t5/QlikView/Compare-a-value-in-a-variable-in-the-script/m-p/307084#M1180843 2012-01-25T17:09:29Z Re: Compare a value in a variable in the script https://community.qlik.com/t5/QlikView/Compare-a-value-in-a-variable-in-the-script/m-p/307085#M1180844 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P><STRONG><STRONG><STRONG><STRONG><STRONG>From sales&nbsp; where sales_account =$(VX)</STRONG></STRONG></STRONG></STRONG></STRONG></P></PRE></BODY></HTML> Wed, 25 Jan 2012 17:31:57 GMT https://community.qlik.com/t5/QlikView/Compare-a-value-in-a-variable-in-the-script/m-p/307085#M1180844 2012-01-25T17:31:57Z