Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rishimessi19
New Contributor

Pivot Table Sub-Totals

- Above chart is a pivot table

- 2 dimensions (one vertical and other horizontal)

- 9 expressions (marked in GREEN)

Question:

1. I do not want subtotals for 2 expressions marked in RED at the bottom. Is it possible?

2.Also, can we have Subtotals - "Top" for one dimension and "bottom" for the other (Option available in presentation tab) ?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Pivot Table Sub-Totals

You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by Robert_Mika

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

1 Reply
Highlighted
MVP
MVP

Re: Pivot Table Sub-Totals

You can use Dimensionality() and SecondDimensionality() to fix this. For more information on these two functions check the blogs by Robert_Mika

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Community Browser