topic Re: Dynamic update in QlikView https://community.qlik.com/t5/QlikView/Dynamic-update/m-p/447549#M167018 <HTML><HEAD></HEAD><BODY><P><STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">UPDATE Projections SET Current=0 WHERE Project = '$(Proj)'</STRONG></P></BODY></HTML> Thu, 10 Jan 2013 23:59:46 GMT 2013-01-10T23:59:46Z Dynamic update https://community.qlik.com/t5/QlikView/Dynamic-update/m-p/447548#M167017 <HTML><HEAD></HEAD><BODY><P>I am using Dynamic Update in Qlikview.</P><P></P><P>I have the following statement:</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><STRONG>UPDATE Projections SET Current=0 WHERE Project = Proj </STRONG></P><P><SPAN style="font-size: 8pt;"><STRONG></STRONG></SPAN></P><P><SPAN style="font-size: 10pt;">Project is a string field in the table and Proj is a variable (string).</SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN><SPAN style="font-size: 10pt;">With "=" in the above statement it never works (ie never sets current to 0). With "IS LIKE" it always works (even when Project and Proj are different strings).</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">What is the correct syntax?</SPAN></P><P><SPAN style="font-size: 10pt;"></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks!</SPAN></P></BODY></HTML> Wed, 24 Oct 2012 10:07:53 GMT https://community.qlik.com/t5/QlikView/Dynamic-update/m-p/447548#M167017 2012-10-24T10:07:53Z Re: Dynamic update https://community.qlik.com/t5/QlikView/Dynamic-update/m-p/447549#M167018 <HTML><HEAD></HEAD><BODY><P><STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">UPDATE Projections SET Current=0 WHERE Project = '$(Proj)'</STRONG></P></BODY></HTML> Thu, 10 Jan 2013 23:59:46 GMT https://community.qlik.com/t5/QlikView/Dynamic-update/m-p/447549#M167018 2013-01-10T23:59:46Z