topic Re: Nested Pie Chart - Different Colors in Each Dimension? in QlikView

Nested Pie Chart - Different Colors in Each Dimension?

Thu, 22 Oct 2015 21:52:37 GMT

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:

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

For example:

Attached find Qlikview

Re: Nested Pie Chart - Different Colors in Each Dimension?

Wed, 22 Jun 2016 20:40:41 GMT

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)

Re: Nested Pie Chart - Different Colors in Each Dimension?

Wed, 22 Jun 2016 20:48:40 GMT

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

Re: Nested Pie Chart - Different Colors in Each Dimension?

Wed, 22 Jun 2016 20:50:40 GMT

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.

Re: Nested Pie Chart - Different Colors in Each Dimension?

elyM — Thu, 23 Jun 2016 01:00:02 GMT

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/4348373

Regrards,

Ely

Re: Nested Pie Chart - Different Colors in Each Dimension?

Thu, 23 Jun 2016 23:11:42 GMT

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

Thanks, Ely.