topic Re: Pivot Table Chart Format in QlikView

Pivot Table Chart Format

Anonymous — Fri, 04 Sep 2015 12:10:07 GMT

I have several pivot tables in my application. On all of them it is showing a bold face line at the end of the dimension headers cell. In this case between Age Band and # of Females. See PNG attached. Anyone know how to get rid of this. I have tried custom format cell, but I have not been successful. The line sticks out lick a sore thumb

Re: Pivot Table Chart Format

Fri, 04 Sep 2015 12:41:59 GMT

what value do you have in the 'Current Style' field on the Style tab.

I can duplicate if the value is 'Basic', 'Pivot1' and some other settings - try changing the value to 'Light'

Re: Pivot Table Chart Format

sinanozdemir — Fri, 04 Sep 2015 12:44:57 GMT

Hi Mike,

In the Style tab of the pivot table properties, you need to un-check "Vertical Dimension Cell Borders".

Hope this helps.

Re: Pivot Table Chart Format

Anonymous — Fri, 04 Sep 2015 12:47:37 GMT

I used the custom format cells, so it change my current style to custom. I went and change it to Light first and then went back and added my custom formatting and it fixed my problem. Thanks for your quick response.

Re: Pivot Table Chart Format

Anonymous — Fri, 04 Sep 2015 12:48:25 GMT

Thanks for replying Sinan. I did play with those check boxes, but they affected more of the grid than I wanted to change.

Re: Pivot Table Chart Format

Fri, 04 Sep 2015 12:49:04 GMT

this will work as well but you would loose the lines between the dimensions - the bold line is a result of the combiantion of cell bofer on dimension and cell border on expression - it is overlaying (double line) on the last dimension and first expression

Re: Pivot Table Chart Format

Digvijay_Singh — Fri, 04 Sep 2015 12:49:43 GMT

You need to uncheck below in style tab -