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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Coloring a horizontal dimension in a pivot table based on dimension value

Is it possible to change the background color of a HORIZONTAL dimension field in a pivot table based on its value?  I can get it to work when the pivot dimension is vertical, but not when going across the top.

In my attached example, i have 2 pivot tables.  The first one correctly highlights the dimension labels based on its valyue of A. B and C.  However, the second pivot does not work because the dimension is pivoted horizontally.

Any ideas?

Thanks,

Andrew

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Looks ok to me:

comm89374.png

What's the problem?

edit: no problems here in QV10 SR3 or QV11 SR2 or QV11.2 SR1/2/3


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Looks ok to me:

comm89374.png

What's the problem?

edit: no problems here in QV10 SR3 or QV11 SR2 or QV11.2 SR1/2/3


talk is cheap, supply exceeds demand
Not applicable
Author

Interesting... that is not what i see.  I do not see any coloring on the second chart.  What version of QlikView are you using?

Not applicable
Author

Sorry for all of the previous replies.  When I try to reply, it says an error has occured, when in reality it actually posted he message.

This is what I see.   What version of QlikView are you using?

test.PNG

UPDATE:  Looks like it may be a bug in the current version I am using.  The above image is from version 11 SR1.  I downloaded and opened the same application in version 11 SR 2 and saw the colors correctly on the second pivot.