Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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
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:
Have you tried Chart Properties>Style>Cell Borders Transparency - Set to 100%.
Worked for me to clear all the borders on the Pivot Table.
Setting the Design Grid "On" (View > Design Grid) was the perfect solution for me. Thank you!