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

Hi,

I'm new to qlik sense, below is the attachment of pivot table.

I'm facing null values in the pivot table, can one help me how remove nulls and how to make gray color into white.

1 Reply
bellamae
Specialist
Specialist

in edit mode you can unselect the show nulls on the rows of your pivot table but null values always show up as gray so I don't think there is anything you can do about the cell colour.

Capture19.PNG