How can I get consistent colors in a native pixel perfect pie chart within each "level" of the report?

[Molly]

Hi, 

I am creating a Native Pixel Perfect Pie Chart of Patient Appointment Types and have added a level of "Clinic", so that I'm generating a pie chart of each of my clinics.

When I run the report, the colors assigned to each slice of the pie (or each appointment type) change based on the value of the slice of pie from Clinic to Clinic. I am looking to keep the colors consistent among each pie based on the dimension. Is this possible? 

For example, I would like the color of each "Established Appts" slice of the pie to be the same color, from Clinic to Clinic. (same with each Appt type: Unfilled, New, No Show and Cx within 24 hours). 

#Nprinting, #PixelPerfect, #NativePieChart, #PersistentColors

[Ruggero_Piccoli]

Hi,

I searched for a solution but I was not able to find a way to force the same value to have the same color in two or more different charts but I had not found a solution. You can select a palette, customize or create new palettes but I did not find a way to associate a specific color with a value.

You could evaluate creating the charts in Qlik Sense and export them as images in PixelPerfect.

Best Regards,

Ruggero

[Molly]

Thank you for looking. I've read about persistent colors as a setting in qliksense, do you know if there is anything like that as an option in pixel perfect? I'm new to building in pixel perfect and there seems to be so many options, I was just wondering if I was missing it. 

Thank  you again, 

Molly

[David_Friend]

@Molly - Ruggero is one of the top Nprinting people at Qlik, so if I would go with his second suggestion of exporting as images from QlikSense, that also makes the most sense to me!

[Frank_S]

Hi Molly,

Are you using the sort order feature by any chance. If so, using that might be causing the issue.

Try using the default settings - none - rather than changing the sort order (if you are changing the default that is.

I've done a few tests and could not reproduce what you are experiencing.

Kind regards...

cc @Ruggero_Piccoli

[Lech_Miszkiewicz · Accepted solution]

@Frank_S - when reproducing have you considered tha dimensions values for 1st pie chart may have values asy A,B and C and for the second chart only B and C? (A  - is not even in the source object as usually we don't show 0 values). 

Or

Do you suggest enabling showing 0 values in Qlik Sense which in turn would force chart to plot all values also those with 0 in it and therefore would retain cosisten colours?

cheers

[Molly]

I worked and worked on this and finally came up with that solution! I forced the 0% to show, so that all the graphs had the same Appointment types whether there was a value or not and then I ended up sorting by the argument, rather than the value. The legend doesn't sort from highest to lowest values, but I'm ok with that! Now the colors are consistent on each clinic's pie chart, and I was able to order the Red color in the palette to be the "unfilled" appointments each time (the category we wanted to draw the reader's eye to). 

[Lech_Miszkiewicz]

And to add to  my previous post - pie charts usually are sorted by values so yeah - sort order is important and in this case is based on % value so we go from largest slice to the smaller... Are we able to do that and have still consistent colours?

[Molly]

No I wasn't able to keep the sort by value, but the consistency of the colors was more important to my end users. The colors just stay is the same position no matter the size of the slice, but I'm ok with that. 

[Lech_Miszkiewicz]

ok - no worries

cheers