topic Re: Dynamic Update Where Clause with "AND" in QlikView

Dynamic Update Where Clause with "AND"

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

YoussefBelloum — Mon, 26 Feb 2018 12:39:08 GMT

Hi,

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

Anonymous — Mon, 26 Feb 2018 12:54:24 GMT

Many thanks Youssef. It worked

YoussefBelloum — Mon, 26 Feb 2018 13:07:25 GMT

You're welome !

Good luck