Discussion Board for collaboration on QlikView Layout & Visualizations.
- Above chart is a pivot table
- 2 dimensions (one vertical and other horizontal)
- 9 expressions (marked in GREEN)
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) ?
Go to Solution.
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()