topic Re: How to hide a entire column where fields are empty/null. in QlikView

How to hide a entire column where fields are empty/null.

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a problem. I need to hide a few columns depending on the dimension , and I force to give zero.

I tried to hide an entire column if all values are null , but does not work.

"Suppress Zero values" and "Suppress When Value is Null" is checked in both tabs. Is a pivot table.

Cheers!

Re: How to hide a entire column where fields are empty/null.

MK9885 — Tue, 20 Sep 2016 19:26:01 GMT

Can you give a Screenshot of your Table and explain, perhaps a sample qvw?

Re: How to hide a entire column where fields are empty/null.

Anonymous — Tue, 20 Sep 2016 19:30:47 GMT

Hi Kevin,

Have you tried the 'conditional-show' option in the expressions-tab yet?

Maybe you can do something like this in the conditional-show formula:

if(Expression = 0, 0, 1).

This formula assumes that if the expression returns 0 for each individual dimensionvalue, then the grand total of that expression will also be 0.

Of course that doesn't always have to be the case. In those cases you should try an aggr-function where the calculation is made for each dimension value.

Re: How to hide a entire column where fields are empty/null.

Tue, 20 Sep 2016 19:36:25 GMT

the selected columns are those that want to hide

Re: How to hide a entire column where fields are empty/null.

Peter_Cammaert — Tue, 20 Sep 2016 19:36:27 GMT

Expression columns in pivot tables are fixed and cannot be hidden, no matter what their content is.

However, if you have multiple expressions (let's say 3 of them, expr1, expr2 and expr3), you can force them to be displayed as columns for an artificial dimension with values E1, E2 and E3 (or whathever you like) in a ValueList() calculated dimension. The expression for the resulting single expression column will become dependent on the Dimension value and will use the same ValueList() in an IF() function. Now if one of those artificial dimension values produces only Zeroes or NULLs for all other dimension values, the column will automatically disappear.

This technique has been discussed many times before in this community. For example, see here:Hide a column in Pivot Table

Best,

Peter

Re: How to hide a entire column where fields are empty/null.

Peter_Cammaert — Tue, 20 Sep 2016 20:33:45 GMT

ValueList() will be your savior