filter for a null value and fields disappear in pivot table qlikview
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!
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).