Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.