Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to shade in empty boxes under Pivot Table

Hey Guys,

I have a request from my company to create a pivot table to do comparative analysis between two dates. Currently I am getting the data right but not able to shade in missing values under the data point. I posted some screenshots to help better understand the problem.

This is what my table looks like currently. I want every value under 100% to be shaded in gray.

QlikView Table.PNG

This is my end goal. Any one have any ideas on how to accomplish this in qlik? Any insight would be very helpful

How I want Qlik Table to look.PNG

2 Replies
Clever_Anjos
Employee
Employee

could you post your qvw?

Not applicable
Author

Hey Anjos I've added a test qvw with the data and the test excel file.