Qlik Community

Qlik Sense Documents

Documents about Qlik Sense.

See why BI users voted Qlik #1 in 11 categories. GET REPORT

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: