topic Vertical Cell Border lines on Pivot Table and Total Lines in QlikView

Vertical Cell Border lines on Pivot Table and Total Lines

klaus_feldam — Mon, 13 Oct 2014 15:00:57 GMT

I am trying to add vertical Cell Border lines on Pivot Table and Total Lines and finding both to be impossible.

I am aware of the 'Use Borders' feature on the Layout tab, but unfortunately this border doesn't export at all to NPrinting, which we are using for our report distribution solution. Same issue with the Total/Others row on straight tables.

Custom Format Cell with Design Grid turned on, only gives access to lines above and below cell - not left and right of cell.

Anyone aware of any way of handling what should be a fairly basic feature of an advanced BI tool.

Re: Vertical Cell Border lines on Pivot Table and Total Lines

Andrea_Ghirardello — Thu, 16 Oct 2014 12:11:52 GMT

Hi Klaus,

I suggest you contact the support team directly.

Here you can find lots of tutorials and you can give feedback or request support: Customer Feedback for Vizubi

Hope this helps.

Andrea

Re: Vertical Cell Border lines on Pivot Table and Total Lines

prathipsrinivas — Wed, 27 Sep 2017 13:24:17 GMT

Hey Klaus,

Hope you are doing good..!

I suggest you a simple solution to get vertical borders in pivot table.

In Pivot chart properties, under Style tab , change the current style to Basic.

If you do so, perfect cell borders will come across the table.

After that if you want to do any formatting changes like Background color , you can do that using custom format cell option.

Hope it resolves your query.

Cheers,

Prathip