topic Re: Stacked Bar Chart Legend with Custom Colors in App Development

Stacked Bar Chart Legend with Custom Colors

TKendrick20 — Fri, 26 Jun 2015 19:14:51 GMT

I have a stacked bar chart with custom colors. However, when I am using custom colors the option to also display a legend disappears. Is there any way to have a legend show up even though I am using custom colors?

Re: Stacked Bar Chart Legend with Custom Colors

ift_isabelle — Fri, 05 Feb 2016 15:59:35 GMT

I have the same problem. Did you found a solution yet?

Re: Stacked Bar Chart Legend with Custom Colors

Anonymous — Sun, 07 Feb 2016 09:06:45 GMT

As a workaround, perhaps create a text & image object containing the color legends, and put it next to the bar chart.

Re: Stacked Bar Chart Legend with Custom Colors

ift_isabelle — Wed, 24 Feb 2016 10:15:10 GMT

My problem is that I have a Drilldown, so my legend wil change.

Isn't this a bug in the Qlik Sense system?

Re: Stacked Bar Chart Legend with Custom Colors

linoyel — Mon, 13 Nov 2017 05:28:48 GMT

Same problem... any solution for this?

Re: Stacked Bar Chart Legend with Custom Colors

TKendrick20 — Tue, 14 Nov 2017 13:31:01 GMT

As muliadyhartono‌ said. I just created an image and put it next to the chart. The chart is in a mashup, so it doesn't look too bad.

Re: Stacked Bar Chart Legend with Custom Colors

ift_isabelle — Mon, 20 Nov 2017 09:45:08 GMT

In the september release (or maybe June) they fixed a part of this.

In your measure items you can give your measures a color. That color will be used in the charts and legend.

So if you make a measure for always and give it a color, it should be in your legend.

Re: Stacked Bar Chart Legend with Custom Colors

linoyel — Mon, 20 Nov 2017 10:27:24 GMT

Yeah, thanks, that's great!

But I need this functionality for dimensions, not measures...

Re: Stacked Bar Chart Legend with Custom Colors

ift_isabelle — Mon, 20 Nov 2017 11:10:36 GMT

In the november release it is possible (not sure about september).

Make a master dimension and go to value colors (1).

Click on the color right of the dimension value and change it to the desired color (2).

After that go the visualisation and (if not already on) select library colors.

Is this what you want?

Re: Stacked Bar Chart Legend with Custom Colors

linoyel — Tue, 21 Nov 2017 09:08:17 GMT

Yeah, that's the way to do it! Thanks!

The only thing is that I can't find a way to highlight rows in s straight table by this dimension colors.The only way I see there is "Background color expression"/ Is there a way to "pull" the colors from master dim into expression?

Re: Stacked Bar Chart Legend with Custom Colors

ift_isabelle — Thu, 23 Nov 2017 15:31:56 GMT

I don't know a way to pull the colors from the Master dimension.

But what you can try is giving in the RGB code in the script.

Example

So in my app I have data from age by gender.

In the script i added:

Color:

Load * Inline [

Sex, Color

Male, 'RGB(0,0,255)'

Female, 'RGB(255,0,0)'

];

And in my background expression i used:

If(Wildmatch(Sex, '*ale'), Color, Lightgray())

that resulted in this:

Is this what you are looking for?

Re: Stacked Bar Chart Legend with Custom Colors

linoyel — Sun, 26 Nov 2017 12:53:39 GMT

Yeah, that's exactly the strategy I've implemented in my app

I've used the Master dimension colors to use in bar charts, and RGBs in script for the same dimension that match Master dim colors - for background color expressions.

Thanks for all your help!

Re: Stacked Bar Chart Legend with Custom Colors

Sai_Mohan — Thu, 08 Aug 2019 10:06:00 GMT

Hi,

I have same problem of giving legends to stacked bar chart . Here i have used colour by expression so that legends are not visible.

Is there any extension for this to do?

Thanks,

sai

Re: Stacked Bar Chart Legend with Custom Colors

Yop1986 — Tue, 10 Mar 2020 14:36:18 GMT

Hi, the only way i found to do this, was creating a meassure in master items and assigning the color to this.