topic hide column in pivot table with condition in QlikView

hide column in pivot table with condition

Wed, 08 Jan 2014 01:38:20 GMT

Hello,

I'm trying to hide specific columns in pivot table with conditions but failing.

Please tell me if you know how i can achieve it.

The chart I want to make is like the one below.

It has A and B and each of them have different columns.

I thought I can use the option in expression tab

but it doesn't work well and every columns(ColumnA to ColumnF) are showed in both A and B.

Re: hide column in pivot table with condition

Siva_Sankar — Wed, 08 Jan 2014 03:17:34 GMT

Hi,

You do hide / unhide the columns in a pivot table by enabling / disabling the "conditional" checkbox in the "Expressiones" tab of the pivot table, and writing a condition in the box below the checkbox.

Also,

using macro you can use conditional formatting expression or you can write a macro to make coloumn width Zero

Macro would be on expression:

set chart = ActiveDocument.GetSheetObject("CH01") 'Your object ID

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ColWidth = 0

chart.SetProperties p

Regards.

Siva

Re: hide column in pivot table with condition

sureshbaabu — Wed, 08 Jan 2014 03:28:54 GMT

Hello,

Are you trying to use two dimensions in your chart. could you please be clear on what you are trying to hide?

it can be achieved thro the expression tab

thanks

Re: hide column in pivot table with condition

Anonymous — Wed, 08 Jan 2014 04:05:30 GMT

Please be more specific regarding your requirement,

and please post some sample for better understanding..

Re: hide column in pivot table with condition

Wed, 08 Jan 2014 04:54:02 GMT

Thank you all for your help,

After I posted I found Pivot table - Hide/show columns

and this is almost the same as what I wanted to do.

Thank you anyway.