Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Thanks

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to remove null values from Pivot Table

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

Re: How to remove null values from Pivot Table

Hi there,

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

.cell .null-value .value{

color: #ffffff !important;
}