topic Re: Update statement not working in QlikView

Update statement not working

Tue, 19 Apr 2016 18:03:06 GMT

Hi ,

I am using dynamic updates and trying to execute the following sql statement:

"Update [Data] set Category = 'Revenue' where [Line Description] like '*" & descfilter.text &+ "*' AND Category ='Other';"

I get the error

Can someone help here?

Thanks in advance

Regards,

Re: Update statement not working

swuehl — Tue, 19 Apr 2016 22:18:04 GMT

Try

='UPDATE [Date] SET Category = ''Revenue'' WHERE [Line description] LIKE ''*' & descfilter.text & '*'' AND Category = ''Other'';'

Note that I used two single quotes e.g. around Revenue and Other (escaped the single quote), i.e. where ever it looks like double quotes, I've used two single quotes.

Put this expression in a text box. Assuming your descfilter.text shows a unique value like TEST, you should see

UPDATE [Date] SET Category = 'Revenue' WHERE [Line description] LIKE '*TEST*' AND Category = 'Other';

This is how your dynamic update statement should look like, right?

Now copy the full expression into the action statement.

Re: Update statement not working

Wed, 20 Apr 2016 14:30:52 GMT

Hi swehl,

Thanks for your reply

Now its says expected WHERE clause in the Update statement.

Regards,

Re: Update statement not working

swuehl — Wed, 20 Apr 2016 15:15:47 GMT

Can you post the ouput of the expression when put into a text box?