Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

hide column in pivot table

hi

i want to hide a column in a Pivot table with calculate dimensions. See please attached file. I want to hide say, column KPI-1 , NC. There is only one expresion in the table and 4 columns based on the conditions

thanks

6 Replies
mark6505
Partner
Partner

Hi,

As fair as I am aware you can't hide columns with in a pivot table, you thought about maybe calculate the values in script?

Mark

buzzy996
Master II
Master II

hi,

i think u have to modify ur expression accordingly..it's not possible by using same expression&cal dim to hide ur column KP1-1.

HTH

felcar2013
Partner
Partner
Author

hi, thanks,

i am changing the dimensions, and trying a new solution

petter
MVP
MVP

It is possible to almost completely hide some dimensions. You can use a macro to make the columns zero-width. Without the macro you could make them a few pixels wide making them almost invisible.

felcar2013
Partner
Partner
Author

thanks

i was just creating the KPIs in the script and then creating a column for each of them, disadvantage is that i have a Report table with 48 columns and i wanted to cover all cases with 3 columns (TY, +/- %, linear gauge)

thanks anyway

maniram23
Creator II
Creator II

Hi,

try this one it will help full for you.

if(ValueList('KPI1','KPI2')<>'KPI1' and ValueList('NC','C')='NC',

sum({$<comp={1}>} sales),

  if(ValueList('KPI1','KPI2')='KPI1' and ValueList('NC','C')='C',

sum({$<comp={0}>} sales),

  if(ValueList('KPI1','KPI2')='KPI2' and ValueList('NC','C')='NC',

sum({$<comp={1}>} sales),

  if(ValueList('KPI1','KPI2')='KPI2' and ValueList('NC','C')='C',

sum({$<comp={0}>} sales)))))