Pivot table - hide columns

[#1]

Hi All,

How to hide columns in pivot table

I have wave1 and wave2 columns and i have to hide wave1 columns other than total column at Column level.

Please help.

[datanibbler]

Hi,

on the "presentation" tab, you can select any of your columns and there are radio_buttons to show or hide or conditionally show the columns.

[ashfaq_haseeb]

Hi,

You cannot hide columns in pivot table.

You can set width to zero.

look at the below post.

http://community.qlik.com/thread/67354

http://community.qlik.com/message/445835#445835

Regards

ASHFAQ

[aveeeeeee7en]

Hi SelvaDXB

You can use Conditional Hide (Enable condition) and pass any wrong condition like 1>1. It will hide the Column.

Select particular which you want to hide and write this condition.

Hope that works for you.

See the Attchments.

Regards

Aviral Nag

[#5]

Hi All,

I tried and it couldn't do.

I have attached my QV file. Please help.

Thanks

[sudeepkm · Accepted solution]

I do not think it is possible in one table but you can use two table over layered to achieve this.

The table alignment has to be done carefully to accept all sorts of filter selections.

[#7]

Expression-->Select the expression u want to hide--> tick conditional-->Give your condition

[aveeeeeee7en]

See the Attachment.

[#9]

Thanks a lot sudeepkm

[#10]

Thanks a lot Aveeeeeee7en