dynamic update based on selection

[#1]

Hello all,

I am trying to dynamically update fields on a table based on selection from another list.

Let's say this is the table:

Name	Value
abc	1
def	1
xyz	1

and this is the list:

Name
abc
def
xyz

I have an update button that I want to fix its action in a way that when I select from the list, let's say abc and xyz, and I hit the button, only the values of 'abc' and 'xyz' changes.

So the button's action is something similar to this:

UPDATE TableName SET Value = '1123' WHERE match(Name,'$(=GetCurrentSelections(Name))')

However this is not working. Any advice??

Thanks in advance!

[Chanty4u]

=If( only({<[Name] = {$(vName)}>} value),

'UPDATE *

  SET Status = 0

  Where [Name] = $(vName);'

  ,

'UPDATE *

  SET Status = 1

  Where [Name] = $(vName);'

  )

[Chanty4u]

dis too,

Dynamically updating List Boxes based on selections

[#4]

Thank you sureshqv for your reply. But excuse me I am new to qlikview. What do you mean by vName, what does the "v" stand for? It would be great if you can explain more. Thanks in advance.

[tamilarasu · Accepted solution]

Hi,

Create a variable in Variable overview window like below,

Variable Name: vSelections.

Definition :    =If(GetSelectedCount(Name)>0, Concat(Chr(39) & Name & Chr(39),  ',' ,50))

Create a button and select action as "Dynamic Update" and statement like below.

UPDATE TableName SET Value = '1123' WHERE Match(Name,$(vSelections))

Attached sample file against your sample input.

[#6]

Perfect! Many thanks!!

[Chanty4u]

Hmmm nop.

That is variable name

for that there is one document  Please read this

https://community.qlik.com/blogs/qlikviewdesignblog/2013/11/04/the-magic-of-variables

and make helpful from the abve  replys which u got help .

[#8]

Hello again,

This is working perfectly on qlikview client however it is not work in web. Any Ideas?

[tamilarasu]

Hi,

Check whether the below options are enabled and try again.

Settings to enable in

QVW: Document properties -->  Server tab--> Enable Dynamic Data update

Server: QMC-->System-->Setup-->QVS-->Security--> Enable Allow dynamic data update

[jochem_zw]

Think the problem is in the where statement the quotes are missing, see attachment