Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to hide the column in pivot table with conditions

how to hide the column in pivot table on which second column is getting calculated,and after hiding

second column which will not get affected and will shows value properly based on first column which I want to hide

Can any one help ???

7 Replies
sujeetsingh
Master III
Master III

Go to this thread it may help you..

http://community.qlik.com/thread/70461?tstart=0

Not applicable
Author

I want to hide the expression column in which I am calculating the value but that value I am using in next expression

and my condition is that i want to hide that calculated 1st column and resulted 2nd column should be visible

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Try this expression in Conditional.

=if(IsNull([ColumnName]),0,1)   

Regards,

Nirav Bhimani

sivarajs
Specialist II
Specialist II

In QV 11, you can check the box  Conditional in the expression tab and use 0 as the condition that will hide your column.If you dont have QV11 you need to go with straight table presentation tab and check the hide column radio button.Hiding column wont affect your result further

Not applicable
Author

There is one solution for your issue

1) Go to expression => check conditional => =False()

2) Go to Presentation => uncheck supress zero value

That should work.

stantrolav
Partner - Creator II
Partner - Creator II

Write =False() in condition. All Expressions would count for this hided dimension as well.

Not applicable
Author

Just change the color of the values of that column to the same color of the background. (Thats works just fine).

Do the same to the title.