topic Re: Stacked Bar chart Color Issuse in QlikView

Stacked Bar chart Color Issuse

maniram23 — Tue, 04 Sep 2018 07:18:00 GMT

Hi Experts,

I have a stacked bar chart, here we are using two dimensions and two expressions.

here one expression we are using to calculate the values another one is to show the values "text as popup",

The issues is when we are using second expression to show the "Text as Popup" the bar colors are changing automatically.

I tried a lot.

please give me any suggestion.

Please find the attached file for the testing.

Re: Stacked Bar chart Color Issuse

Anonymous — Tue, 04 Sep 2018 07:33:38 GMT

you need to set the Checkbox Persistent Colors

Re: Stacked Bar chart Color Issuse

maniram23 — Tue, 04 Sep 2018 09:17:35 GMT

Hi Linder,

thanks for your replay,

i have to display same color sequence in second chart.

Re: Stacked Bar chart Color Issuse

Anonymous — Tue, 04 Sep 2018 09:27:58 GMT

Hi I donot understand,can you post example (screenshot as I have your application)?

When I try the Colors are the same independant (with checkmark persistent Color)

I am not allowed to upload your qvw with persistent color

Re: Stacked Bar chart Color Issuse

maniram23 — Tue, 04 Sep 2018 09:37:53 GMT

hi Rudolf,

The issue is its working fine in qlik desktop, but once we do a reload and publish it on access point there its getting changed. what's the work around for this.Pl kindly suggest.

Re: Stacked Bar chart Color Issuse

ksomosera10 — Tue, 04 Sep 2018 09:39:02 GMT

Hi Mani,

Just choose "Persistent Color" on the Colors Tab.

Thanks!

Re: Stacked Bar chart Color Issuse

prieper — Tue, 04 Sep 2018 10:48:40 GMT

Under "Background" in the Expression you may enter something like

=PICK(MATCH(Bucket, '0-50', '50-60', '60-70', '70-80', '80-90', '90-100'),
    RGB(255, 255, 0),
    RGB(255, 0, 0),
    RGB(255, 128, 0),
    RGB(128, 128, 128),
    RGB(128, 255, 0),
    RGB(100, 100, 100))

and choose the colors as you wish.

Peter