Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove null values from pivot table

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

Thanks

1 Solution

Accepted Solutions
bill_markham
Champion III
Champion III

For the 2 dimensions untick Show Null Values.

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

View solution in original post

3 Replies
bill_markham
Champion III
Champion III

For the 2 dimensions untick Show Null Values.

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

View solution in original post

arngue
Contributor III
Contributor III

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

publication1
Contributor III
Contributor III

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