topic hide a column in QlikView

hide a column

Fri, 04 Jun 2010 09:38:59 GMT

Hi all,

I have to hide a column when the cells are empty or null.

The formula is

=if(GetFieldSelections(Lib_Analyse,',')='Nb établissements', Sum ({$<[cf_eprd_1]={'CF'}, [cf_eprd_2]={'CF'}>} [es]), 0) so when the result is null on all rows I want to hide the column.

Can you help me.

Thank you

Best regards

Johanna

hide a column

sparur — Fri, 04 Jun 2010 09:58:59 GMT

check on option "Supress Zero ..." on presentation tab in chart properties

hide a column

Fri, 04 Jun 2010 11:01:46 GMT

Hi,

You're takling about "hidding a row", I just want to hide a column when its values are null.

Regards

Johanna

hide a column

quwok — Fri, 04 Jun 2010 11:30:26 GMT

Since you are using expressions, i'll assume you are using a Straight Table.

On the Presentation tab, select the column you like to hide and select 'Conditional'

enter something similiar to the following

= NumericCount(YourColumn) <> 0 or TextCount(YourColumn) <> 0

not sure how efficient this will be on your expression, but i'm sure you get the idea 🙂

hide a column

Wed, 09 Jun 2010 17:20:45 GMT

Thank you.

I am sorry but I have selected the column in the Presentation tab but i don't find "Conditionnal".

Can you explain me where I can find it ?

Thank you

hide a column

Thu, 10 Jun 2010 08:50:31 GMT

Are you using Version 9? The conditional hide on a column is only available in Version 9.

hide a column

Thu, 10 Jun 2010 09:02:11 GMT

Hi,

For straight table it is fine it work . But for pivot table ...where I have my col like this how we can make it work .

Besides in an expression where u have the following cols ..how we can hide/disable an expression :

Volume

Value

COGS

GP = Value-COGS

I want to hide COGS .

rgds

tapas

hide a column

Thu, 10 Jun 2010 10:25:39 GMT

Hi Tapas

You cannot hide a column like this in a pivot table, I don't know of any workaround for this apart from creating two pivot tables, one with the column and one without the column, then you would use a conditional show on each object to control which one is displayed. I'm not sure if this would work for you though.

Regards,