Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
oscar_olaya
Partner
Partner

Remove a measure, and show only in totals

Hi!

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
marcus_sommer
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