topic Re: Hide column,please find this... in QlikView

Hide column,please find this...

Tue, 13 Nov 2012 10:18:12 GMT

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

Re: Hide column,please find this...

renjithpl — Tue, 13 Nov 2012 11:05:19 GMT

Are you using Qlikview 11 ?

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:07:42 GMT

Hi,

Yes i am using QV11 SR1

Re: Hide column,please find this...

renjithpl — Tue, 13 Nov 2012 11:09:49 GMT

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

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

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:18:16 GMT

Hi Renjithpl,

still it is showing zero value.

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

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:28:41 GMT

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

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.

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:44:59 GMT

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

regards,

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:46:20 GMT

i Already did this but its not hiding the column.

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:49:45 GMT

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,

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:51:49 GMT

Hi,

Thanks for your reply,

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

Re: Hide column,please find this...

Tue, 13 Nov 2012 11:54:06 GMT

why do you load these dimensions in you qvw if there are only null values?