Qlik Community

New to Qlik Sense

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

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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‌ even though I uncheck the null value box still getting null  values.


2 Replies

You probably want to do something that's not possible. You can't hide an expression only for some dimension values and not for others. So if there's one dimension value that returns a result then the expression will be shown for all the dimension values with empty cells if there's no result.

talk is cheap, supply exceeds demand

Hi there,

Please create theme and in css add this part of code:

.cell .null-value .value{

color: #ffffff !important;