how to hide the column in pivot table with conditions

[#1]

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 ???

[sujeetsingh]

Go to this thread it may help you..

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

[#3]

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]

Hi,

Try this expression in Conditional.

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

Regards,

Nirav Bhimani

[sivarajs]

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

[#6]

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]

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

[#8]

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.