topic Re: How to remove Grey area in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442680#M432739 <HTML><HEAD></HEAD><BODY><P>It deserve, But we need to hide cells too. Recently i faced same issue. But, Fortunately not due to limitation of pivot table. And i got some clue from Manish thru Whatsapp an easy way we can do using Macro to achieve. I am trying to do the same.</P></BODY></HTML> Tue, 22 Aug 2017 06:53:39 GMT Anil_Babu_Samineni 2017-08-22T06:53:39Z How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442675#M432734 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to remove grey area from the below pivot table ....</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174156_Untitled.png" style="height: 129px; width: 620px;" /></P></BODY></HTML> Tue, 22 Aug 2017 06:27:22 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442675#M432734 prma7799 2017-08-22T06:27:22Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442676#M432735 <HTML><HEAD></HEAD><BODY><P>Not possible</P></BODY></HTML> Tue, 22 Aug 2017 06:28:37 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442676#M432735 Anil_Babu_Samineni 2017-08-22T06:28:37Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442677#M432736 <HTML><HEAD></HEAD><BODY><P>Directly it is not possible.. but you can think of putting a text box over the area</P></BODY></HTML> Tue, 22 Aug 2017 06:45:33 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442677#M432736 sushil353 2017-08-22T06:45:33Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442678#M432737 <HTML><HEAD></HEAD><BODY><P>As Sushil suggest you have to make trick for this </P><P></P><P>Ex:-</P><P>1. Text box layout properties should be Top over the pivot table.</P><P>2. Pivot table properties should be bottom.</P><P>3. Text box background color should be white or your define colour</P><P></P><P>HTH</P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 22 Aug 2017 06:50:58 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442678#M432737 its_anandrjs 2017-08-22T06:50:58Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442679#M432738 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>It can be done, try to change the Cell color background transparency to 100%.</P><P>like below screen</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174157_Capture.JPG" style="height: 365px; width: 620px;" /></P></BODY></HTML> Tue, 22 Aug 2017 06:51:07 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442679#M432738 devarasu07 2017-08-22T06:51:07Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442680#M432739 <HTML><HEAD></HEAD><BODY><P>It deserve, But we need to hide cells too. Recently i faced same issue. But, Fortunately not due to limitation of pivot table. And i got some clue from Manish thru Whatsapp an easy way we can do using Macro to achieve. I am trying to do the same.</P></BODY></HTML> Tue, 22 Aug 2017 06:53:39 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442680#M432739 Anil_Babu_Samineni 2017-08-22T06:53:39Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442681#M432740 <HTML><HEAD></HEAD><BODY><P>This works only when sheet background is white else it shows the color of your sheet.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 22 Aug 2017 07:01:10 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442681#M432740 its_anandrjs 2017-08-22T07:01:10Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442682#M432741 <HTML><HEAD></HEAD><BODY><P>Hi Anand,</P><P>Yeah. if you want both (remove pivot gray color and apply custom header color) then we have go try with macro option.</P><P></P><P>Thanks, Deva</P></BODY></HTML> Tue, 22 Aug 2017 08:02:16 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442682#M432741 devarasu07 2017-08-22T08:02:16Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442683#M432742 <HTML><HEAD></HEAD><BODY><P>Can you publish the macro code?</P></BODY></HTML> Fri, 15 Sep 2017 11:56:22 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442683#M432742 Frank_Hartmann 2017-09-15T11:56:22Z Re: How to remove Grey area https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442684#M432743 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Can you publish the macro code?</SPAN></P></BODY></HTML> Fri, 15 Sep 2017 11:56:30 GMT https://community.qlik.com/t5/QlikView/How-to-remove-Grey-area/m-p/1442684#M432743 Frank_Hartmann 2017-09-15T11:56:30Z