Qlik Community

Qlik Sense Documents & Videos

Documents & videos about Qlik Sense.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today

Custom totals in Qlik Sense tables

Custom totals in Qlik Sense tables

Question

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

 

 Answer 

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)
Comments
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

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