Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yuvaraj_g
Contributor III
Contributor III

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)?

nakul1001
Creator II
Creator II

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