Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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
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
Hi All,
I tried and it couldn't do.
I have attached my QV file. Please help.
Thanks
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.
Expression-->Select the expression u want to hide--> tick conditional-->Give your condition
See the Attachment.
Thanks a lot sudeepkm
Thanks a lot Aveeeeeee7en