Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 

Remove a measure, and show only in totals


In pivot table, i need show a measure only in total

In the image, it is necessary to eliminate columns red and leave the green in totals


Labels (3)
1 Reply
MVP & Luminary
MVP & Luminary

It's not possible to show or hide the columns of an expression if they is below of any dimension and returned at least a single result for any cell-value.

A workaround for you could be to add those 'Total' as an additionally field-value to your Dim1 (it could be done with a small concatenate-statement from an inline-table) and then to query this value within the expression. Another way is to add another (maybe artificial) dimension above Dim1 - if none native exists it might be just a calculate dimension with a string like 'all Dim1 value' - and then you could query the dimensionality, for example like:

if(secondarydimensionality() = 0, ExprDato2, ExprDato1)

- Marcus