I am using Dynamic Update in Qlikview.
I have the following statement:
UPDATE Projections SET Current=0 WHERE Project = Proj
Project is a string field in the table and Proj is a variable (string).
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).
What is the correct syntax?
Thanks!
