topic How do i hide expression column in Pivot table in QlikView

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 05:25:47 GMT

Dear All,

How do i hide Expression Column in Pivot table ??

Can anyone help me !!

Regards,

Antony.

How do i hide expression column in Pivot table

Anonymous — Tue, 28 Jun 2011 06:07:13 GMT

If you don't want it at all you can uncheck the Enable checkbox under the Chart Properties > Expressions tab

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 06:33:48 GMT

Dear Johan,

Thanks for your reply.

I want to hide the Expression not Disable. when i require that time i want to Expand or visible the Hide Expression, is it possible in Pivot table.

The same thing i can do it in Straight table but i want it in Pivot table.

Regards,

Antony

How do i hide expression column in Pivot table

Anonymous — Tue, 28 Jun 2011 06:50:26 GMT

Ok, are you hiding/showing the expression using a macro? In that case you can use a macro to enable/disable the expression instead.

In that case look up the Enable API in the API guide in the IExpressionData class.

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 07:22:29 GMT

How do i use macro in Pivot ???

How do i hide expression column in Pivot table

Anonymous — Tue, 28 Jun 2011 08:25:06 GMT

How do you hide the expression in the straight table?

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 08:44:35 GMT

In Straight we have two options Hide column & Conditional Column. these options are not available in Pivot.

Re: How do i hide expression column in Pivot table

deepakk — Tue, 28 Jun 2011 08:45:07 GMT

hi,

PLease find a sample file for hiding and unhiding expression using macro.

Deepak

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 08:49:17 GMT

Deepak,

i checked its not hiding, its just showing some cross mars on above the object.

Antony.

How do i hide expression column in Pivot table

deepakk — Tue, 28 Jun 2011 08:58:06 GMT

hi Antony,

Create a new one or change it to line chart and check.. Its working fine in my system.

Deepak

How do i hide expression column in Pivot table

Tue, 28 Jun 2011 08:59:31 GMT

Ok i'll check it & let u know...

Thanks,

Napolean.