Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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)))))