filter for a null value and fields disappear in pivot table qlikview

[lucassmitt]

Good Morning,
I have a question about qlikview, I am starting.
I have a chart of a pivot table.
it has many dimensions and three expressions that are very simple (sums).
The problem is that every time I filter by a null value of a dimension, fields disappear, that is, all dimensions appear and only expressions represent me.
On the other hand, if I filter by a value that is NOT null, if I see all the information, that is, I see all the dimensions and the three expressions.
can you help me? It's urgent.
Thanks!

example:

filter for a null value (marked in red):

and the result is:

what I want is that when filtering by a null value (marked in red) it remains as the first image. (showing all the information).

pivot table

Thanks!

[Maria_Halley]

@lucassmitt 

I will move this post to the QlikView App development section. 

I think your question can be better answered there.

[lucassmitt]

Thank you very much Maria!

[stevejoyce]

Are you saying, if you filter by a non-null value you want your object to filter to just those value(s).  But if you filter to null value, you do not want it to filter that dimension at all?

[lucassmitt]

no, what I want is that when I filter for a null value, it shows me the entire row, with all dimensions and expressions

[Andre_Sostizzo]

@lucassmitt, maybe this will help, but I see that you'll looking for same behavior with a pivot table.

https://community.qlik.com/t5/New-to-Qlik-Sense/Freeze-Multiple-columns-in-straight-table-Qlik-sense...