Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pennetzdorfer
Creator III
Creator III

Pivot table border color

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?

CustomFormatCell 1.png

8 Replies
sujeetsingh
Master III
Master III

Try this

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

pennetzdorfer
Creator III
Creator III
Author

Default Styling Mode is already activated ...

pennetzdorfer
Creator III
Creator III
Author

Any ideas ...?

amit_saini
Master III
Master III

Not applicable

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....

Not applicable

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.

krishna20
Specialist II
Specialist II

Hi ,

Like this attached app ??

krishna20
Specialist II
Specialist II

Try this,

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