Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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

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
3 Replies

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

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

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

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

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?

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.

Community Browser