Dynamic update using multiple selections

[#1]

Hello,

I would like to use the dynamic update function based on multiple selections. I have it working for 1 selection, but when I select 2 values the update function will not work.

This is how I have done it:

I first created a variable. By clicking on a button, the variable (vPersoonsgebonden) will be set by the statement =GetFieldSelections(DisplayName). This is working correctly.

Next, I created a button that will execute the update statement:

UPDATE Users SET Type_account = 'Persoonsgebonden' WHERE DisplayName='$(=vPersoonsgebonden)';

Now, whenever selecting one value, the update function is executed correctly. Whenever selecting more than one value, the function is not executed.

Any help would be appreciated.

Thanks in advance.

[tamilarasu · Accepted solution]

Hi Luc,

Follow the steps below:

Variable Name:

VUpdate

Definition:

=If(Getfieldselections(DisplayName)>0,Concat('Update Users SET Type_account=' & chr(39) & 'Persoonsgebonden' & chr(39) & ' Where DisplayName=' & chr(39) & DisplayName & chr(39) , ';' & chr(13)) )

Button statement (Dynamic Update):

=VUpdate

Let me know.

[#3]

Works like a charm! Thank you!

[tamilarasu]

Glad to hear from you. Thanks settu_periasamy .

If your question has been answered, I suggest marking my reply as correct to close the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful.

Have a nice day.