topic Re: Pivot Table in QlikView

Pivot Table

Thu, 09 Jan 2014 07:47:24 GMT

Hi all,

How to hide expressions in pivot table

Thanks & regards,

Nagaraju

brijesh1991 — Thu, 09 Jan 2014 07:49:28 GMT

Hide is straight table functionality, you can't do with PIVOT.

You can manage pivot functionalities in straigh table by writing multiple expressions

jagan — Thu, 09 Jan 2014 07:52:37 GMT

Hi,

You can hide expression column in pivot table using the macro

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,

Jagan.

Thu, 09 Jan 2014 09:09:06 GMT

Hi Nagaraju,

There is a option called Conditional in Expression Tab use this option to hide until the condition satisfies.

Thu, 09 Jan 2014 10:45:53 GMT

Expressions can be conditionally hidden by checking "Conditional" check bx in expressions tab on pivot table.

But this option is available from QV 11 and not in the versions below.