topic Re: Color in stacked bar in QlikView

Color in stacked bar

sergio0592 — Sat, 16 Nov 2024 05:03:53 GMT

Hi all,

I can't manage the following issue. I have a stacked bar chart with two dimensions dim1 and dim2. Dim2 has the values : RED/GREEN/YELLOW/GREY.

So when Dim2=RED, i want background color is red. It works only for some cases but not for all. I use a table color (which usually fix the issue) and as background color :

=color or =only({<Dim1>}color) but both don't works.

Any idea?

Thanks

Re: Color in stacked bar

hopkinsc — Tue, 04 Dec 2018 15:07:13 GMT

Hi, can you post an example?

Re: Color in stacked bar

sergio0592 — Tue, 04 Dec 2018 15:47:50 GMT

I can't manage to reproduce the issue on a sample for the moment.

Re: Color in stacked bar

sergio0592 — Tue, 04 Dec 2018 15:57:16 GMT

I manage to fix it with trying reproducing in a sample.

As expression i have a cumulative sum of sales with =

sum({$<MONTH={"<=$(=num(MONTH))"}>} SALES)
/
sum({$<MONTH={"<=$(=num(MONTH))"}>} TOTAL <Dim1> SALES)

So it works if as background color i have = Only({<MONTH>} color)