topic Re: Dynamic Update Help in QlikView

Dynamic Update Help

Anonymous — Mon, 27 Jul 2015 14:58:38 GMT

Hi All,

I need help with dynamic update statement where user make changes to inputbox 'Company', TempDate' or 'Value' and reflected back on "Test" table with the updated information. Lets say i selected company 'ABC' and make changes to the value '100' to '200'. i want the '200' value to reflected on the 'Test" table.

In my current process, user select one item on "Test" table, then select "Populate Item" button. Please see attached qvw. Any inputs will greatly appreciated!.

Thanks,

Frank

Re: Dynamic Update Help

sunny_talwar — Mon, 27 Jul 2015 15:53:24 GMT

You need to use the table name from your database:

Update Statement:

UPDATE Temp SET Value = '$(vValue)' WHERE Company='$(vCompany)';

HTH

Best,

Sunny

Re: Dynamic Update Help

Anonymous — Mon, 27 Jul 2015 16:32:20 GMT

Thanks. It works!

Sunny- would you happen to know if the'value' field still works with dynamic update if value numbers are base on calculation? such as A+B = Value field

Re: Dynamic Update Help

sunny_talwar — Mon, 27 Jul 2015 16:34:47 GMT

This was my first time with Dynamic Update. I am not sure if it will work or not.

But having said that, we might be able to test it out by creating two variable vValue1 and vValue2 and adding them up to see if it works

I am going to check it now

Best,

Sunny

Re: Dynamic Update Help

sunny_talwar — Mon, 27 Jul 2015 16:37:27 GMT

This seems to work:

UPDATE Temp SET Value = '$(=$(vValue1) + $(vValue2))' WHERE Company='$(vCompany)';

Re: Dynamic Update Help

Anonymous — Mon, 27 Jul 2015 18:39:03 GMT

Thanks.

Agree. It does works with multiple variables. But the value field that calculated dont seems to be working with dynamic update. This value field that im using consist of sum(A & B) where A & B has its condition to generate in the load script. I provided you a wrong situation in above message for "A+B=Value field". It should be the sum(A&B) situation.

I appreciate you looking into this.

Many Thanks,

Frank