topic Re: Pivot table border color in QlikView

Pivot table border color

pennetzdorfer — Thu, 27 Nov 2014 09:48:14 GMT

Hello,

I noticed a strange behavior when using Custom Format Cell for a pivot table.

Apparently it's not possible to change the border color of expressions ... settings only apply to dimensions.

Please find the attached qvw. Does anybody have an idea?

Re: Pivot table border color

sujeetsingh — Thu, 27 Nov 2014 09:52:36 GMT

Try this

, User Preferences>> Design>>Set Default Styling Mode Advanced.

Re: Pivot table border color

pennetzdorfer — Thu, 27 Nov 2014 10:56:13 GMT

Default Styling Mode is already activated ...

Re: Pivot table border color

pennetzdorfer — Mon, 01 Dec 2014 12:08:02 GMT

Any ideas ...?

Re: Pivot table border color

amit_saini — Mon, 01 Dec 2014 12:17:53 GMT

Florian,

This may help you:

Re: Change color of pivot table expression line

Re: custom row colors in pivot table

Thanks,
AS

Re: Re: Pivot table border color

Mon, 01 Dec 2014 12:26:27 GMT

actually in pivot table Total row consider a different row you need to format total separately,and on partial total too,if you make changes on one of partial sum total it will change all partial sum total for that dimension....

Re: Pivot table border color

Wed, 16 Sep 2015 10:54:58 GMT

try to switch to another chart style by right click pivot table--properties--style--current style, then try again to change bg color via customer format cell, at least for me it works, I met the same weird situation before.

Re: Pivot table border color

krishna20 — Fri, 18 Sep 2015 11:12:39 GMT

Hi ,

Like this attached app ??

Re: Pivot table border color

krishna20 — Fri, 18 Sep 2015 11:16:19 GMT

Try this,

Disable Design grid and Enable. You will get custom cell format could be activated.