How to remove null values from pivot table

[#1]

How to remove null values from pivot table in qlik sense with two dimensions and measure.

Thanks

[Anonymous · Accepted solution]

For the 2 dimensions untick Show Null Values.

For the expression, under Data Handling you may wish to consider unticking Show zero values.

[arngue]

This don't work with multiple expressions, first expresion nulls keep showing.

[publication1]

depending on what your trying to do you can remove Null Values or add WHERE X >=1 if your column holds numerical data.