Pivot table: Suppress NULL/missing values only in specific situations

fbuerger — Mon, 16 Jul 2018 06:49:59 GMT

Hi there,

I am having a pivot table and would like to suppress NULL/missing values just for some specific cases.

I am starting with this pivot table:

Now I am filtering on the last 4 weeks - So far so good:

Additionally I am filtering on specific Building:

As you can see from the result, this building only has results in Bereich 1 and Bereich 2, but Bereich 3 also belongs to the chosen building. I now like to see all the ones suppressed which don't belong into the chosen building (Bereich 4 to 9), but keep Bereich 3 even if it doesn't have any results. Same with 2018/21.

Like this:

Qlikview only gives me that:

I am happy about every small idea 🙂

Thanks for you help!

topic Pivot table: Suppress NULL/missing values only in specific situations in QlikView

Pivot table: Suppress NULL/missing values only in specific situations