Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[Solved] How to hide column whith only null values

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?

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

conditionnal expression :

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


View solution in original post

4 Replies
martin59
Specialist II
Specialist II

conditionnal expression :

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


Not applicable
Author

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())

Not applicable
Author

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.

Marcel_Garcia
Contributor III
Contributor III

Marcel_Garcia_0-1657801950524.png