Discussion Board for collaboration on QlikView Layout & Visualizations.
How can I change background color to a header in a Pivot Table, but only some columns header?
This columns are expressions and I need change background color in some columns header not in all.
For example, I have a Pivot Table like this:
And I need distinct background color in the columns header of the expressions (Sales in Yellow and Cost in Green) , like this:
How can I do it?
I need your help!!!
As far as I know wyou can only achieve that using some visualization tricks.
Using the layer level you can overlap the object and then usings their respective color properties, you can get an aproximate color custom solution of the pivot or straight tables headers.
Check the file attached and see if it satisfy your need
This post http://community.qlik.com/message/261681 may do this job. Let me know once you tested it.
This is ver y easy
Right click on chart -> "Custome format cell" and chnage the color for that particular cell BG.
The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".
Can you explain clearyl????
see the attached file hope it helps you