QlikView supports a special type of field, which indeed can be changed without script execution, the input field.
An input field is just like any other field in QlikView, with the difference that its values, as read in the script, can later be changed without running the script again. Input fields can be used like any other fields in all types of sheet objects.
When using input fields, the script creates placeholders for each field
value, which can later be edited to contain new data. Any field can be
turned into an input field by listing it in an
Values of an input field can be changed in list box cells, table box cells and in table chart expression cells. Only list boxes and table columns which contain input fields are editable. By hovering over an editable cell it is possible to see an input icon. Clicking on the icon sets the cell in input edit mode. It is possible to use up/down arrow keys to move between cells while staying in input edit mode. The entire QlikView document will automatically recalculate whenever new values are entered.
A table chart expression cell may contain a special input field aggregation function and still be open for input. The change will then be distributed back to the underlying field values, based on predefined algorithms, such as e.g. "spread equally" or "spread proportionally".
It is possible to specify relative change.
The following syntax applies (n is a number):
| %+n | increases the current value by n% |
| %-n | decreases the current value by n% |
| +=n | increases the current value by n |
| -=n | decreases the current value by n |
| *=n | multiplies the current value with n |
| /=n | divides the current value with n |
Example:
%+10 increases the current value with 10%.
+=56 increases the current value with 56.
*=2 multiplies the value with 2.
/=2 divides the value with 2.
/=0 no change.
There are also Automation APIs for extracting and setting values programmatically.