Qlik Community

Ask a Question

Qlik Sense Documents

Qlik Sense documentation and resources.

Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY

Custom totals in Qlik Sense tables


Custom totals in Qlik Sense tables


How to use custom formulas for totals rows/columns in Qlik Sense tables. This works for both straight and pivot tables.


 Custom columCustom colum       Custom rowCustom row



Check the option to display totals for the desired dimension (in pivot tables) or measure (in straight tables).

For a custom totals row, use:

If(Dimensionality() = 1,
    123,    // Expression for regular rows
    999     // Expression for totals

For a custom totals column, use (only in pivot tables):

If(SecondaryDimensionality() = 1,
    123,    // Expression for regular columns
    999     // Expression for totals
Labels (3)
Specialist II
Specialist II

Will this work with Valuelist conditions and Column(1)-Column(2) kind of expressions when calculating the Totals(Dimensionality being 0).

It does not seem to work in both cases for me

Version history
Revision #:
2 of 2
Last update:
‎2018-12-05 09:51 AM
Updated by: