Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik2019
Partner - Contributor II
Partner - Contributor II

Hide column in ..Pivot Table ..using valuelist

Hi Folks,

Facing issue with conditional show hide in pivot using value list.

Have attached the file with explanation. 

In value list i have "One" and "Two" columns. For "One" column I intend to show only months (Apr, May and June) and for "Two" I intend to show the net differences (Diff Jun, Diff May etc ) only.. But currently it is showing all in both "One" and "Two" column means under column "One" I have Apr, May, June, Diff May, Diff Jun and In column "Two" also appears Apr, May,Jun,Diff May, Diff Jun.

What I want to achieve is under column "One" There should only be months i.e Apr, May and June and under column "Two" should be only difference i.e Diff May, Diff June..

I tried condition show column but its not working .. It hides that month from both column One/ Two..

Thanks All !!

0 Replies