topic Re: Stacked Bar Chart - Colors by Dimension in QlikView

Stacked Bar Chart - Colors by Dimension

Mav70 — Tue, 16 Jun 2020 10:47:28 GMT

Hi,

I have several stacked bar charts with 2 dimensions - Stage and RAG status. Each chart measures a particular RAG (e.g. effort, schedule etc) - see attached. I need to use consistent colors across the charts whereby a Green RAG is always green, a Red RAG is always red, an Amber RAG is always Amber and an "Unset RAG" is grey. Depending on the dayta there may not always be all 4 RAGs on each chart.

Setting the colors on the Color tab doesn't work due to this last point. Any ideas how this can be achieved?

Thanks in advance,

Re: Stacked Bar Chart - Colors by Dimension

jwjackso — Tue, 16 Jun 2020 16:18:11 GMT

On the Colors tab, is "Persistent Colors" checked?

Re: Stacked Bar Chart - Colors by Dimension

Mav70 — Tue, 16 Jun 2020 17:05:54 GMT

Hi,

Yes, have tried that but to no avail.

Re: Stacked Bar Chart - Colors by Dimension

Brett_Bleess — Thu, 02 Jul 2020 12:22:53 GMT

Have a look at the following Design Blog post, hopefully that may do the trick for you:

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-custom-color-a-stacked-bar-chart/ba-p/1465653

Regards,
Brett

Re: Stacked Bar Chart - Colors by Dimension

Mav70 — Fri, 18 Sep 2020 08:36:28 GMT

Thanks both. Have this sorted now.