Dynamic update action on current selection

Wed, 16 Jul 2014 20:15:09 GMT

Hi all, hoping someone can help....

I'm building application that needs to get the Dynamic Update action.

Basically I have a field in the data table called "REVIEW_STATUS" and I want to use dynamic update action (via action button) to update this field on selected records to say "Reviewed". (By default the field says UnReviewed).

I can use the dynamic update like this

UPDATE Table SET Review_Status = 'Reviewed' WHERE Country='UK';

..... but I don't want it to say " WHERE Country='UK'..... I want it to say something like

UPDATE Table SET Review_Status = 'Reviewed' on currently selected records

Any ideas what the syntax is for the "on currently selected records" bit??

Many thanks if someone can help

topic Dynamic update action on current selection in QlikView

Dynamic update action on current selection