topic Re: Cell borders on Pivot table in QlikView

Cell borders on Pivot table

vlad_komarov — Fri, 22 Feb 2013 17:12:28 GMT

I have a pivot table with multiple dimensions and one expression.

The last dimension (Contract Clause) is pivoted:

I have couple issues with chart's cells:

1. The cell border for Pivoted dimension is much thicker than the rest of the cells (#1 above)

2. There is no vertical border between two last dimensions (#2 above).

I've tried different chart styles, but was not able to change this view.

I would appreciate your suggestions.

Best regards,

Vladimir

Re: Cell borders on Pivot table

Gysbert_Wassenaar — Fri, 22 Feb 2013 17:19:58 GMT

It should be possible with themes I think. Take a look for example at the Clean style on the Style tab.

Re: Cell borders on Pivot table

vlad_komarov — Fri, 22 Feb 2013 17:43:05 GMT

I do not think themes apply to cell's style. I do not see an option to change the cell's options anywhere there. It looks like themes are covering Color schema, Backgrounds, Caption's style only.

And Clean style dims the existing cell borders a bit and removes some lines if specified, but I need to have all cell to have a same border styles, like Excel.

Re: Cell borders on Pivot table

Wed, 26 Mar 2014 20:13:23 GMT

you should try the "custom format cell". To enable it:

1. press the "design grid'

2. after that you'll see the new option "custom format cell" when you right click any cell of the pivot table.

Hope that helps!

Re: Cell borders on Pivot table

sameera — Mon, 01 Apr 2019 19:50:38 GMT

I was trying to give a specific background to one dimension in my Pivot table. 'Custom Format Cell' works perfectly. Thanks !