Qlik Sense Documents

Qlik Sense documentation and resources.

Last Update:

Dec 5, 2018 9:51:30 AM

Updated By:

Created date:

Dec 5, 2018 9:50:22 AM

Question

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

Custom colum Custom 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
)

Rate this article:

Who rated this article

Partner - Contributor

Rating date:

Who rated this article