topic Dynamic Update Not working in QlikView

Dynamic Update Not working

Anonymous — Thu, 30 Jul 2015 17:21:11 GMT

Hi All,

I'm working on a dynamic update with IRR % caculation. In my current process, i select one row, hit "populate items" button, update "FinalValue" inputbox, then hit "Update". I'm not sure what went wrong with my below statement. Please help.

UPDATE Final SET FinalValue = '$(vFinalValue)' WHERE Company='$(vCompany)';

For example:

i want to update the FinalValue to 100 from 150 for ABC company where Final_Date is 8/15/2013.

Many Thanks,

Frank

Re: Dynamic Update Not working

sasiparupudi1 — Fri, 31 Jul 2015 14:23:24 GMT

There is no Update functionality in qlikview

Re: Dynamic Update Not working

petter — Sat, 01 Aug 2015 07:31:41 GMT

There is in fact and update functionality in QlikView. It is called DYNAMIC UPDATE. However it is not a full-blown full-circle write-back feature - you will have to implement that yourself or use a third-party

The Dynamic Update is documented (very lightly) on page 559 in Chapter 39.3.

Furthermore Dynamic Update is not very reliable and it seems like it is considered a legacy feature.

Re: Dynamic Update Not working

petter — Sat, 01 Aug 2015 07:44:06 GMT

Your UPDATE statement fails because your data model has several tables with the field named FinalValue.

So either you have to fix your data model removing the synthetic key or you have to use * instead of Final to

tell QlikView to update all tables that has the field FinalValue like this:

UPDATE * SET FinalValue = '$(vFinalValue)' WHERE Company='$(vCompany)';

Re: Dynamic Update Not working

Anonymous — Mon, 03 Aug 2015 15:03:11 GMT

Thank You Sasidhar and Petter for your inputs. Most likely i might need to consider alternative solutions with third party.