Skip to main content Skip to complementary content


inputsum() returns the aggregated sum of inputfield iterated over the chart dimension(s). inputfield must be a field name of a field properly declared as an input field in the script.


inputsum(inputfield [, distribution_mode][set_expression])

When this aggregation function is used as expression in a table chart, it will be possible to edit the aggregated sum interactively. When hovering over the expression cell you will 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 change in the aggregated sum will be distributed to the underlying field values using the chosen distribution_mode. The entire QlikView document will automatically recalculate whenever new values are entered.

The distribution_mode parameter can have the following values:

distribution_mode parameter values
Parameter Description
'+' Default mode. Equal parts of the change are distributed to all the underlying values.
'*' The change is distributed proportionally (to existing values) to the underlying values.
'=' The value entered is given to all the underlying values.

The value is divided equally between underlying values, without regard to previous distribution but keeping previous sum.

The distribution_mode values in the previous table can be amended with the following modifiers:

distribution_mode parameter value modifiers
Modifier Description
T E.g. '+T'. Will cause a compensation of the entered change over the other selected values in the input field (keeping the grand total intact).
A E.g. '+A'. Will cause a compensation of the entered change over all other values (keeping the grand total intact).


inputsum (Budget )

inputsum (Budget, '+' )

inputsum (Budget, '*' )

inputsum (Budget, '=' )

inputsum (Budget, '/' )

inputsum (Budget, '+T' )

inputsum (Budget, '+A' )


Learn more


Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: