Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to hide single column in pivot table

sample.png

from above pivot table i want to hide sum(amount) column.

thanks,

Yuvaraj

3 Replies
adamdavi3s
Master
Master

If you hide your only expression then the chart will have nothing to show?

sunny_talwar

What is the point of showing this chart without Sum(amount)?

Anonymous
Not applicable
Author

Unlike Straight table, hide or show column feature is not available in Pivot table.

What is that you are trying to achieve having a pivot table with multiple dimension but no measure (expression) ?

If it purely for cosmetic reason, there are a few ways to do:

  1. hit spacebar in the Expression Label box (to give it a blank value)
  2. change the representation to LED GAUGE and in the Gauge setting, make the color transparent
  3. Then squeeze the column border to reduce the width as much possibleimage1.PNG