Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

fanko1225
Contributor

Dynamic Update Not working

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

Tags (3)
4 Replies
Highlighted
sasiparupudi1
Honored Contributor III

Re: Dynamic Update Not working

There is no Update functionality in qlikview

Highlighted
MVP
MVP

Re: Dynamic Update Not working

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.

Highlighted
MVP
MVP

Re: Dynamic Update Not working

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)';

Highlighted
fanko1225
Contributor

Re: Dynamic Update Not working

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