Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Hide column,please find this...

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

10 Replies
renjithpl
Valued Contributor

Re: Hide column,please find this...

Are you using Qlikview 11 ?

Not applicable

Re: Hide column,please find this...

Hi,

Yes i am using QV11 SR1

renjithpl
Valued Contributor

Re: Hide column,please find this...

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

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

Not applicable

Re: Hide column,please find this...

Hi Renjithpl,

still it is showing zero value.

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

Not applicable

Re: Hide column,please find 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.

Not applicable

Re: Hide column,please find this...

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

regards,

MT

Not applicable

Re: Hide column,please find this...

Hi

i Already did this but its not hiding the column.

Not applicable

Re: Hide column,please find this...

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

Not applicable

Re: Hide column,please find this...

Hi,

Thanks for your reply,

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

Community Browser