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

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

Wed, 14 Aug 2013 12:23:04 GMT

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

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

Gysbert_Wassenaar — Wed, 14 Aug 2013 12:36:55 GMT

Looks ok to me:

What's the problem?

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

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

Wed, 14 Aug 2013 12:47:06 GMT

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

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

Wed, 14 Aug 2013 12:49:22 GMT

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.