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.
Re: Coloring a horizontal dimension in a pivot table based on dimension value
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?
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.