Nested Pie Chart - Different Colors in Each Dimension?

[#1]

Summary:

I want a "nested pie" in Qlikview, because it's closest to this "sunburst".

It's easy to add two dimensions to achieve this effect.

But my user could be confused when the color blue is used in both dimensions

For example, blue represents "Nate" but also represents "Apple" in this image:

Question:

1. Can I get the inner dimension, "Customer" to use one set of colors
2. And outer dimension, "Product", to use a different set of colors?

For example:

Attached find Qlikview

[#2]

The special Dimensionality() function seems  promising; specifically there is a difference between inner pies and outer pies' Tooltip.

But I don't think I can act on this difference (attached)

[#3]

I was also toying with RowNo() and FieldIndex() but neither gives me the results I expect

[#4]

I also hoped the "Persistent Colors" checkbox (Colors tab) might be configurable, so I could choose a different palette for different dimensions (i.e. mutually exclusive palettes ensure they can't use a common color). But I don't think I can do anything beyond checking the "Persistent Colors" checkbox.

[elyM · Accepted solution]

Hi Nathaniel,

you have seen third party solution about Sunburst chart.

Qlik Branch

GitHub - countnazgul/ZoomableSunburst: Qlikview extension based on http://bl.ocks.org/mbostock/43483...

Regrards,

Ely

[#6]

I hoped I could avoid extensions, but if I must use an extension, I prefer github-hosted, open-source, and d3!

Thanks, Ely.