topic Re: [Solved] How to hide column whith only null values in QlikView

[Solved] How to hide column whith only null values

Fri, 13 Aug 2010 13:35:32 GMT

Hi all,

In a simple chart I would like to hide column only if it contain only null values.

It's easy to hide column with conditionnal expression.

The problem is how to know there is only null values in column.

Any idea?

Re. :How to hide column whith only null values

martin59 — Fri, 13 Aug 2010 13:38:50 GMT

conditionnal expression :

if(sum(TOTAL Field)=null(),1,0)

Re. :How to hide column whith only null values

Fri, 13 Aug 2010 14:02:38 GMT

Thanks for this answer.

sum(TOTAL Field) returns 0 with only null values.

This works better for me :

<blockquote><pre> if(sum(TOTAL Field)=0,false(),true())

How to hide column whith only null values

Fri, 13 Aug 2010 14:07:11 GMT

Hi,

The problem is that he want to supress a Column and not a Row. When show zero values in all columns the rows are supress but he want just the column needed to supress.

If your chart is Straigth Table, in properties -> Presentation, have a option to show conditional the column, but in pivot table doesn't exist this parameter.

Re: [Solved] How to hide column whith only null values

Marcel_Garcia — Thu, 14 Jul 2022 12:32:42 GMT