Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic update

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!

1 Reply
Not applicable
Author

UPDATE Projections SET Current=0 WHERE Project = '$(Proj)'