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!