Use color by expression to match pie chart and bar graph colors?

[#1]

Hello,

I want to color by expression in my bar chart so that the colors of the different Notification types match the colors in the pie chart.

I know I can use IF statements to color by expression in my gar graph (i.e. If([Notifictn type]='DR", green (), blue()), but how can I figure out what the exact colors are in the pie chart so that the colors will match?

[Gysbert_Wassenaar · Accepted solution]

The pie chart can also be configured to use an expression to assign colors to the segements. You can use an expression like =Color(FieldIndex('Notifictn type',[Notifictn type])) to always give each dimension value the same color. As long as you use the same expression in all the charts you'll get the same colors.

[#3]

Thank you - do I use that expression in the appearance section where I would color by expression or in the data load editor?

[#4]

When I use that expression I get an error saying that the data set contains negative values

[Gysbert_Wassenaar]

Please post a small Qlik Sense document that demonstrates the problem.

[vgadang1]

Worked for me, super helpful!

[Prem0212]

In the apperance  section you would see the option of color by expression so that you can use the custom colors for both the charts.

or else you can use the custom theme.