
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how to hide columns in pivot table
Hi,
I am new to qlikview. Can u anyone can help me in this.
Upon selection last 5 columns need to hide....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may describe more to understand the logic?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi prathap, you'll need to give more info about what selection should hide the columns to get a specific solution.
As a general solution: In the expressions tab of the chart, check the 'conditional expressions' chekbox, set an expresion that return false (or zero) when you want hide to columns and true (or any number<>0) when you want to show the columns.
Hope this helps!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please post a sample app so people here can help you better
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Ruban,
Thanks its working fine..
Thanks to all who responded to my question...


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Prathap,
I agree with Ruben! you can also refer the below link:
Re: Pivot table Hide measure column based on dimension value?
Regards!
Rahul


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).
If not, please make clear what part of this topic you still need help with .


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In pivot table--expressions-->Conditional...
Presentation-->
