Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you using Qlikview 11 ?
Hi,
Yes i am using QV11 SR1
Under expression tab, you have an option "Conditional" on top,
check that box, and give [Your Expression] <>0
Hi Renjithpl,
still it is showing zero value.
is there any other solution for this.....
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.
hi go in you chart properties -> presentation -> select Suppress Zero-Values
regards,
MT
Hi
i Already did this but its not hiding the column.
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
Hi,
Thanks for your reply,
I enabled this one also,but no changes....