topic Re: Pie Chart Colors Different From Legend Colors in QlikView

Pie Chart Colors Different From Legend Colors

Mon, 03 Dec 2012 17:22:24 GMT

Hi, I'm pretty new to QV and I'm using V10. I've made a two-dimensional pie chart with a calculated expression color. The legend seems to display the correct/expected color; however, the chart doesn't. In the attached image I've hovered over a slice with an unexpected color, and the corresponding legend color is shown to be different. What am I doing wrong? Thanks! -Reid

Re: Pie Chart Colors Different From Legend Colors

Mon, 03 Dec 2012 17:32:05 GMT

Also, hovering over the second dimension slices, it looks like those colors match the legend's. This chart displays the two next-deepest levels in a Hierarchy().

Dimension 1:

//we're at a subtree
=IF($(vHighestSelectedLevel) = 0,[Hierarchy Name1],
IF($(vHighestSelectedLevel) = 1,[Hierarchy Name2],
IF($(vHighestSelectedLevel) = 2,[Hierarchy Name3],
IF($(vHighestSelectedLevel) = 3,[Hierarchy Name4],
IF($(vHighestSelectedLevel) = 4,[Hierarchy Name5],
IF($(vHighestSelectedLevel) = 5,[Hierarchy Name6],[Hierarchy Name6]))))))

Dimension 2:

=IF($(vLowestSelectedLevel) - $(vHighestSelectedLevel) >= 1,
IF($(vHighestSelectedLevel) = 0,[Hierarchy Name2],
IF($(vHighestSelectedLevel) = 1,[Hierarchy Name3],
IF($(vHighestSelectedLevel) = 2,[Hierarchy Name4],
IF($(vHighestSelectedLevel) = 3,[Hierarchy Name5],
IF($(vHighestSelectedLevel) = 4,[Hierarchy Name6],
IF($(vHighestSelectedLevel) = 5,[Hierarchy Name7],[Hierarchy Name7]))))))
, 0 )

Re: Pie Chart Colors Different From Legend Colors

Thu, 27 Dec 2012 17:46:18 GMT

In the chart, it looks like the color that an inner slice gets is equal to that of its clockwise-most child slice.