topic Re: Stacked Bar Chart - Segment Colors in App Development

Stacked Bar Chart - Segment Colors

Fri, 03 Oct 2014 19:37:38 GMT

In QlikView, when using a stacked bar chart and using multiple expressions for each segment/stack you could control the individual color of the segment/stack.

It looks like you might be able to do the same in QlikSense but it would have to be done via one formula for all charts. What is the proper formula we should be using in this one formula field to control the colors for each individual segment/stack that would be the most efficient with large data sets?

Re: Stacked Bar Chart - Segment Colors

Fri, 03 Oct 2014 19:57:09 GMT

Additionally, when selecting the color by expression option the show legend option disables.

How would I make a stacked bar chart with 3 expressions (1) Good, (2) Marginal, (3) Bad for example so that Good would be in Green, Marginal in Yellow and Bad in Red and have a legend indicating that.

Please note the expressions and colors indicate are purely for discussion and problem clarification. We do understand colors and color blindness impact.

Re: Stacked Bar Chart - Segment Colors

Tue, 07 Oct 2014 11:43:53 GMT

Is the only way to achieve this by adding an extension? Could this be added as a feature request?

Re: Stacked Bar Chart - Segment Colors

Tue, 07 Oct 2014 22:30:41 GMT

Have you tried to add a Gauge and go to Appearance, then Presentation and check the Use Segments?

Here you can select the segments and the color associated to it

Re: Stacked Bar Chart - Segment Colors

Wed, 08 Oct 2014 13:14:34 GMT

I don't believe a Gauge will work. As I mentioned we need a bar chart. We have to be able to display dimension(s) with several thousand values.

Does anyone know how to obtain the native javascript utilized for the bar chart and for the guage, so we could have someone look at creating an extension with the functionality? Or are we able to inherit the existing bar chart and extend its paint functionality to incorporate the necessary color control?

Re: Stacked Bar Chart - Segment Colors

demonioazul — Thu, 08 Oct 2015 20:20:10 GMT

https://community.qlik.com/message/884034#884034

Re: Stacked Bar Chart - Segment Colors

reddy-s — Tue, 15 Dec 2015 09:36:04 GMT

Hi Brain,

You can colour a stacked bar chart in the following way. Take this as an Example.

Use these expressions:

Dimension 1: year-month

Dimension 2: valuelist( 'achieved', 'justmissed' and 'missed')

Measure : if(valuelist( 'achieved', 'justmissed' and 'missed') = 'achived',<expression1>,

if(valuelist( 'achieved', 'justmissed' and 'missed') = 'justmissed',<expression2>,

if(valuelist( 'achieved', 'justmissed' and 'missed') = 'missed',<expression3> )))

Colour Expression:

if(valuelist( 'achieved', 'justmissed' and 'missed') = 'achived',lightgreen(),

if(valuelist( 'achieved', 'justmissed' and 'missed') = 'justmissed',yellow(),

if(valuelist( 'achieved', 'justmissed' and 'missed') = 'missed',lightred() )))

Check this for a QVF sample.

How to use custom colours in a stacked bar chart