topic Re: dynamic update based on selection in QlikView

dynamic update based on selection

Tue, 09 Feb 2016 10:19:16 GMT

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!

Re: dynamic update based on selection

Chanty4u — Tue, 09 Feb 2016 10:23:56 GMT

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

'UPDATE *

SET Status = 0

Where [Name] = $(vName);'

'UPDATE *

SET Status = 1

Where [Name] = $(vName);'

)

Re: dynamic update based on selection

Chanty4u — Tue, 09 Feb 2016 10:25:39 GMT

dis too,

Dynamically updating List Boxes based on selections

Re: dynamic update based on selection

Tue, 09 Feb 2016 10:51:10 GMT

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.

Re: dynamic update based on selection

tamilarasu — Tue, 09 Feb 2016 11:07:09 GMT

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.

Re: dynamic update based on selection

Tue, 09 Feb 2016 11:37:08 GMT

Perfect! Many thanks!!

Re: dynamic update based on selection

Chanty4u — Tue, 09 Feb 2016 11:39:40 GMT

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 .

Re: dynamic update based on selection

Sat, 13 Feb 2016 06:55:59 GMT

Hello again,

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

Re: dynamic update based on selection

tamilarasu — Sat, 13 Feb 2016 15:51:02 GMT

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

Re: dynamic update based on selection

jochem_zw — Tue, 21 Jan 2020 09:03:12 GMT

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