topic Re: Colors in a pie chart with calculated dimension in QlikView

Colors in a pie chart with calculated dimension

Cige — Fri, 12 Jul 2019 19:57:50 GMT

Hi experts,

I'm trying to get familiar with the tool and thanks to your advices and examples I've been able to solve the majority of my every day problems, but not this one.

In this paricular case I'm trying to understand how the colors of my pie chart are assigned in order associate the right one to the desired value of my calculated dimension.

I created a sample of data and highlighted the problem I'm facing with the Black color.
Despite being able to order the values of my legend with the Dual() function when I arrange the colors in the proper tab those seem to ignore the order I created and proceed with the 'original' order of the labels.

Am I missing something here or do you know a better way to end up with the expected result??

Thanks a lot for your much appreciated help!
Best regards,
Cige

Re: Colors in a pie chart with calculated dimension

Lisa_P — Mon, 15 Jul 2019 00:25:29 GMT

The colors are according to the data, or measure, not dimension

Re: Colors in a pie chart with calculated dimension

Cige — Mon, 15 Jul 2019 00:41:06 GMT

And that could help me find the solution?

Re: Colors in a pie chart with calculated dimension

Brett_Bleess — Wed, 07 Aug 2019 15:28:15 GMT

Here is a Design Blog post related to chart colors:

https://community.qlik.com/t5/Qlik-Design-Blog/Colors-in-charts/ba-p/1475280

Here is the Help for Pie Chart object:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Pie_Chart.htm

Have a read through those and see if you find your answer there, if not, or if something is confusing the doc, shout back, and we can try to find further info at that point, but to Lisa's point, it seems you may be going at things incorrectly, which is why I am posting the links for you to check things there first.

Regards,
Brett