Hide column,please find this...

[#1]

Hi,

Can anyone know the solution for this,how to hide the columns which is having zero values.

Please find the attachment,in this i am having 13 expressions Field1 to Field12 and total.I drag and droped the dimension called code to vertical.

In Code1 i am having only Field10,Filed12 and total expressions remaining all fields are null values,like this i am having 12 fileds which related to their codes.

Now i want to hide the Fileds which is having null values that is not related to codes in pivot table,is it possible can anyone help me in this...

regards,

baru

[renjithpl]

Are you using Qlikview 11 ?

[#3]

Hi,

Yes i am using QV11 SR1

[renjithpl]

Under expression tab, you have an option "Conditional" on top,

check that box, and give  [Your Expression] <>0

[#5]

Hi Renjithpl,

still it is showing zero value.

is there any other solution for this.....

[#6]

I don´t really get it why you want to hide the null values but it might work in script

if(Len(Trim(Field1))=0, "Here you can add you´re favourite expresion","else expression") as FieldName

or

NullAsValue Field1;

Set NullValue = 'you´re expression for null values';

or without script (but this doesn´t work all the time if you import it from excel)

right click on your pivot, properties, presentation , then you can define how null values should be displayed.

BUT i think you can´t remove them completely from a pivot-table.

[#7]

hi go in you chart properties -> presentation -> select Suppress Zero-Values

regards,

MT

[#8]

Hi

i Already did this but its not hiding the column.

[#9]

ok than go properties-> dimensions -> select Suppress When Value Is NULL

i'm not sure though if this will work but give it a try

regards,

MT

[#10]

Hi,

Thanks for your reply,

I enabled this one also,but no changes....