Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table-background color

Hello Team,

In straight table,we can change the bg color to pyjama green,pyjama red and pyjama blue.

likewise how to change it in pivot table??

Thanks in advance

Labels (1)
4 Replies
robert_mika
MVP
MVP

In Style tab-->Current Style

See example

Not applicable
Author

Thanks for your reply.Due to personal edition cant open your qvw..

Could you please post a screenshot of it?

Not applicable
Author

PFACapture.JPG

Not applicable
Author

Thank you for your reply.

but my requirement is to show alternative colors.

while using bg color expression, it shows correct.

if(odd(F2),rgb(153,180,51),Green())

but when we expand this pivot table, it get mixed.

How to overcome this??

Capture143.PNG