topic How to shade in empty boxes under Pivot Table in QlikView https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374773#M822189 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>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.</P><P></P><P>This is what my table looks like currently. I want every value under 100% to be shaded in gray.</P><P><IMG __jive_id="172969" alt="QlikView Table.PNG" class="jive-image image-1" height="296" src="/legacyfs/online/172969_QlikView Table.PNG" style="height: 295.75px; width: 455px;" width="455" /></P><P>This is my end goal. Any one have any ideas on how to accomplish this in qlik? Any insight would be very helpful</P><P><IMG __jive_id="172973" alt="How I want Qlik Table to look.PNG" class="jive-image image-2" height="347" src="/legacyfs/online/172973_How I want Qlik Table to look.PNG" style="height: 347.372px; width: 445px;" width="445" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z How to shade in empty boxes under Pivot Table https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374773#M822189 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>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.</P><P></P><P>This is what my table looks like currently. I want every value under 100% to be shaded in gray.</P><P><IMG __jive_id="172969" alt="QlikView Table.PNG" class="jive-image image-1" height="296" src="/legacyfs/online/172969_QlikView Table.PNG" style="height: 295.75px; width: 455px;" width="455" /></P><P>This is my end goal. Any one have any ideas on how to accomplish this in qlik? Any insight would be very helpful</P><P><IMG __jive_id="172973" alt="How I want Qlik Table to look.PNG" class="jive-image image-2" height="347" src="/legacyfs/online/172973_How I want Qlik Table to look.PNG" style="height: 347.372px; width: 445px;" width="445" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374773#M822189 2020-11-25T16:16:04Z Re: How to shade in empty boxes under Pivot Table https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374774#M822190 <HTML><HEAD></HEAD><BODY><P>could you post your qvw?</P></BODY></HTML> Wed, 09 Aug 2017 19:32:22 GMT https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374774#M822190 Clever_Anjos 2017-08-09T19:32:22Z Re: How to shade in empty boxes under Pivot Table https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374775#M822191 <HTML><HEAD></HEAD><BODY><P>Hey Anjos I've added a test qvw with the data and the test excel file. </P></BODY></HTML> Wed, 09 Aug 2017 20:41:49 GMT https://community.qlik.com/t5/QlikView/How-to-shade-in-empty-boxes-under-Pivot-Table/m-p/1374775#M822191 2017-08-09T20:41:49Z