topic Re: How to remove a cell border from Pivot table in QlikView

How to remove a cell border from Pivot table

jayabedin — Wed, 25 Nov 2020 16:16:04 GMT

Hi There,

I am using QlikView 12.10.

We developed a pivot table with two dimensions and a measure. Can't find a way to avoid an extra cell mark. Find the picture below for consideration. Any help will be highly appreciated.

Regards

Jay

Re: How to remove a cell border from Pivot table

Sergey_Shuklin — Fri, 13 Oct 2017 12:21:55 GMT

Hello, Jay!

If your Styling Mode is Advanced (ctrl + alt + d -> Styling Mode) click on that square and choose Custom Format Cell.

There are two options "Border Before Cell" and "Border After Cell" - try to make them blank (white).

Should help to hide that cell.

Re: How to remove a cell border from Pivot table

HirisH_V7 — Fri, 13 Oct 2017 13:07:09 GMT

Hi,

To have the "Custom Format Cell" in the Context Menu of a Pivot Table, you need to go to the menu "View" and active "Design Grid".

There you can remove your Borders.

-Hirish

Re: How to remove a cell border from Pivot table

jayabedin — Mon, 16 Oct 2017 22:10:43 GMT

Hi Hirish,

I can manage all other border except the Pivot marking.

I tried custom format. None of the option works for me.

Hope someone find a work around.

Regards

Jay

Re: How to remove a cell border from Pivot table

Sergey_Shuklin — Wed, 18 Oct 2017 16:44:30 GMT

Hello!

Hm, it's strange because it works for v11 but doesn't for v12.

Still you have an option to set the same color for background as for borders, just like that:

Re: How to remove a cell border from Pivot table

ZoeM — Wed, 18 Apr 2018 13:10:42 GMT

Have you tried Chart Properties>Style>Cell Borders Transparency - Set to 100%.

Worked for me to clear all the borders on the Pivot Table.

Re: How to remove a cell border from Pivot table

justaqlikker — Fri, 15 Feb 2019 17:22:39 GMT

Setting the Design Grid "On" (View > Design Grid) was the perfect solution for me. Thank you!