Skip to main content
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

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

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.