topic pivottable: Show also Null values in QlikView

pivottable: Show also Null values

Wed, 25 Nov 2020 16:16:04 GMT

Dear experts,

I have a problem with displaying of the Null values in pivottable. If I select the "Filter"-value, then corresponding entry will be not displaying. In the property-->presentation I don't set "Nullwerte weglassen". I want that all Applications always be shown in the corresponding Technologiecluster. Java-Cluster is an example.

By Property -->Dimension-->Application I set "Alle Werte Anzeigen"

Kind regards for your support

Re: pivottable: Show also Null values

MK9885 — Wed, 02 Nov 2016 17:48:43 GMT

Correct me if I understood wrong.

But you can go to

Properties>Dimension>Uncheck 'Supress When Value Is Null'

It will show you all null values as well

Re: pivottable: Show also Null values

Thu, 03 Nov 2016 09:54:06 GMT

In my properties --> dimension I already set: "Show all values" In properties --> Presentation: uncheck "Suspress Zero-Values" and the values in "Application" are still not shown.

Re: pivottable: Show also Null values

MK9885 — Thu, 03 Nov 2016 17:00:02 GMT

Check this link below and also search for any other related discussions on showing null values.

How to display NULL values as 'NULL' instead of '-'

Re: pivottable: Show also Null values

Fri, 04 Nov 2016 09:56:43 GMT

I inserted into my Script, but it still not working.

NULLASVALUE *;

SET NullValue ='NULL' ;

If I set some filters and there are no values, then the affected application will not shown. I just want to "fix" or "show also Nullvalues" column application.

Re: pivottable: Show also Null values

jonathandienst — Fri, 04 Nov 2016 10:03:10 GMT

The problem may be that the values are MISSING rather than null - this can be caused by an incomplete association between tables where the key field(s) exists in only one of the tables. Expressions using fields from the other table will be missing, not null. The workaround is to add records to populate the missing associations in some way.

Re: pivottable: Show also Null values

jonathandienst — Fri, 04 Nov 2016 10:06:08 GMT

How to populate a sparsely populated field

NULL handling in QlikView

Generating Missing Data In QlikView

Re: pivottable: Show also Null values

Fri, 04 Nov 2016 10:35:46 GMT

It's correct! I have inserted in my mapping-table the missing entries and now I get all values! Thank you !