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)';
i want to update the FinalValue to 100 from 150 for ABC company where Final_Date is 8/15/2013.
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.