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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamic Update Where Clause with "AND"

Hello,

I'm trying to achieve a dynamic update with 2 or more conditions. Can I put an "AND" in the where clause?

Example: ActiveDocument.DynamicUpdateCommand("DELETE FROM TableX WHERE Deal_ID = '1' AND Counter = '2'")

Does it work in Qlikview?

Thanks

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

If your question is only about the AND on the where, so YES you can put AND on your where clause.

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

If your question is only about the AND on the where, so YES you can put AND on your where clause.

Anonymous
Not applicable
Author

Many thanks Youssef. It worked

YoussefBelloum
Champion
Champion

You're welome !

Good luck