topic Dynamic Update, update row on selected field in QlikView

Dynamic Update, update row on selected field

Anonymous — Tue, 29 May 2012 06:26:04 GMT

Hi,

I'm trying to write a dynamic update similar to this:

UPDATE Table SET field1= $(vVariable) WHERE field2='23';

But instead of the number in the where statement i want it to be a selected field. How do i do this? I've tried getfieldselected and the concat function but i didn't get it to work.

Thanks!

//A.

Dynamic Update, update row on selected field

Tue, 29 May 2012 07:59:30 GMT

Hi,

could you please explain if you're talking about script or setanalysis.

I don't understand where do you want to use that expression.

Regards

Giampiero

Dynamic Update, update row on selected field

Anonymous — Tue, 29 May 2012 08:02:14 GMT

sorry.

it's in the action "dynamic update" in my case, this action is set to trigger on a button click. I'm using QlikView 11 where dynamic update is available in an action without the need to write a macro for it.

Dynamic Update, update row on selected field

Tue, 29 May 2012 08:16:11 GMT

I see,

I'm sorry if I don't well understood.

I'll try to see.

Re: Dynamic Update, update row on selected field

Wed, 22 Aug 2012 23:17:42 GMT

The trick is to use expansion with evaluation: $(=......)

E.g. UPDATE Table SET field1= $(vVariable) WHERE field2='$(=only( [Field2] ))'

Re: Dynamic Update, update row on selected field

sebastiandperei — Thu, 23 Aug 2012 01:47:32 GMT

Hi,

I Don't really know in witch part you want to put the selection, but in "Macro World", the selection is referenced by:

ActiveDocument.Fields("Field").GetPossibleValues,

ActiveDocument.Fields("Field").GetSelectedValues or

ActiveDocument.Fields("Field").GetMemberValue(3) (the 3 could be anyone, if selection has more than one)