Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Dynamic Update - WHERE ID IN (1,2,3,4)

Can anyone help me to get the correct dynamic update syntax here

These don't seem to work

UPDATE TABLENAME SET GROUPID = 1 WHERE ID IN (1,2,3,4);

UPDATE TABLENAME SET GROUPID = 1 WHERE ID=1 OR ID=2 OR ID=3 OR ID=4;


Thanks in advance!


Felix

2 Replies
Highlighted
Creator II
Creator II

Hi Richard,

I have tried with the first one update query it is working perfectly,

Kindly try once again with

Update <tablename> set <fieldname> =<value> where <fieldname> in (<values for condition>);

Example I have used the below expression,

Update dbo.tbl_Womens_Registration set emp_Id =1 where emp_id in(101,102,103);

and got output as shown below

Capture.PNG

Highlighted
Not applicable

That works, as you have demonstrated, in SQL. I'm talking about Qlikview Dynamic Updates