Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jayabedin
Contributor III
Contributor III

How to remove a cell border from Pivot table

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.

Extra Cell.PNG

Regards

Jay

6 Replies
Sergey_Shuklin
Specialist
Specialist

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.

HirisH_V7
Master
Master

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

HirisH
“Aspire to Inspire before we Expire!”
jayabedin
Contributor III
Contributor III
Author

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

Sergey_Shuklin
Specialist
Specialist

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:

extra_cell.png

ZoeM
Specialist
Specialist

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

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

justaqlikker
Contributor III
Contributor III

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