topic Re: Dynamic update using multiple selections in QlikView

Dynamic update using multiple selections

Wed, 29 Jun 2016 11:31:34 GMT

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.

Re: Dynamic update using multiple selections

tamilarasu — Wed, 29 Jun 2016 16:27:11 GMT

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.

Re: Dynamic update using multiple selections

Thu, 30 Jun 2016 13:30:07 GMT

Works like a charm! Thank you!

Re: Dynamic update using multiple selections

tamilarasu — Thu, 30 Jun 2016 16:20:40 GMT

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.