Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
There is no Update functionality in qlikview
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.
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)';
Thank You Sasidhar and Petter for your inputs. Most likely i might need to consider alternative solutions with third party.