topic Extra column in Pivot Table in QlikView

Extra column in Pivot Table

Tue, 24 Mar 2015 05:33:15 GMT

Hi All,

I want to hide the extra column in pivot table. Attaching the screenshot and

sample application along. Please help me to achive the same.

Thanks,

Anoop

sushil353 — Tue, 24 Mar 2015 05:49:07 GMT

Hi,

It seems you can't get rid of that extra column..

but you can do a work around to make it invisible.

1. Make that column width minimum as much possible.

2. Get the background color of that header cell similar to the line..

there are some settings you can adjust in Style tab of chart property.

HTH

Sushil

prma7799 — Tue, 24 Mar 2015 05:53:53 GMT

Hi Anoop,

I think we can not remove column in pivot table but you try like below.

Thanks

Anonymous — Tue, 24 Mar 2015 06:11:47 GMT

instead of hiding it off I follow the practice to label it with symbol '->' which helps use to understand data

Anonymous — Tue, 24 Mar 2015 06:13:29 GMT

i think this will put user in confusion if they do send to excel and see additional column

prma7799 — Tue, 24 Mar 2015 06:16:33 GMT

Yes you are right but i think there is no option to hide column.