topic Re: hide column in pivot table in QlikView

hide column in pivot table

felcar2013 — Mon, 16 Nov 2015 13:48:14 GMT

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

Re: hide column in pivot table

Mark_Little — Mon, 16 Nov 2015 13:54:52 GMT

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

Re: hide column in pivot table

buzzy996 — Mon, 16 Nov 2015 14:08:16 GMT

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

Re: hide column in pivot table

felcar2013 — Mon, 16 Nov 2015 14:21:28 GMT

hi, thanks,

i am changing the dimensions, and trying a new solution

Re: hide column in pivot table

petter — Mon, 16 Nov 2015 15:04:49 GMT

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.

Re: hide column in pivot table

felcar2013 — Mon, 16 Nov 2015 15:36:38 GMT

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

Re: hide column in pivot table

maniram23 — Mon, 16 Nov 2015 17:07:15 GMT

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