QuestionHow to use custom formulas for totals rows/columns in Qlik Sense tables. This works for both straight and pivot tables. Custom colum Cu...
Show More
QuestionHow 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
)
Show Less