topic QlikView Pivot Hide empty variance column in QlikView

QlikView Pivot Hide empty variance column

Fri, 04 Sep 2015 10:49:40 GMT

Hi everybody,

my question is really simple:

How can I hide the empty variance column diff?

I tryed expression for column => =if(isnull(before(sum(Wert))),0,1) and =if(isnull(before(sum(Wert))),false(),true())

Already tryed suppress nulls and missing in pivot options...

Thx in advance!

Re: QlikView Pivot Hide empty variance column

Gysbert_Wassenaar — Fri, 04 Sep 2015 12:55:30 GMT

You can't. An expression column will be shown for each year if there's at least one year where that expression returns values.

But I don't see any column that doesn't have values, so I don't understand what you want to hide.

Re: QlikView Pivot Hide empty variance column

Fri, 04 Sep 2015 13:00:46 GMT

you can check the supressing zero values and missing values options on the presentation tab but that will only accomplish if there is no data for the column and/or row

Re: QlikView Pivot Hide empty variance column

Sat, 05 Sep 2015 08:40:05 GMT

thank you for answering...

my intention is to Hide the diff column for 2014 as it contains no data and just takes up space that can be filled with usefull information for the application user

Re: QlikView Pivot Hide empty variance column

Sat, 05 Sep 2015 08:45:18 GMT

Thank you for clarifiying the supressing null and missing value function. But as stated this is not the task i want to accomplish; I want to Hide the column 2014 - diff because it just takes space and has no interesting information for the end user of the app.