Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
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
MVP & Luminary
MVP & Luminary

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
Contributor III
Contributor III

Hi there,

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

.cell .null-value .value{

color: #ffffff !important;