How to use custom colours in a stacked bar chart

[#1]

Hi there,

I am struggling to colour a stacked bar chart in custom colours. If you take belows chart as an example, I would like to e.g. replace the green with black, the purple with turquoise etc.

This example chart is auto-colour by QlikSense in the multicolored>12 colors mode.

I defined my custom colours as e.g. "kGreen", "kBlue" and usually use nested if-expressions to custom-colour my charts.

With the stacked bar chart, however, the issue is that my six different measures are six columns of the same facts table and the if-statements don't work.

Thank you very much for your help!

[santhoo_san]

You can use your color conditions in the expression box under 'Colors and legend' > Custom colors > By Expression

[#3]

Hi Santhosh,

thanks for your reply! Yes, I know that but I don't know how my if-expressions should look like.

Could you give me an example?

Thanks!

[#4]

Hi David,

I think you will find this part of the video useful - Qlik Sense developer tutorial - YouTube

It starts from 49':45"  and it is called "Consistent colors and good vizual design".

To make it easy for you the formula is as follows:

pick(match("OICA region",'Africa','Americas','AOME','Europe'),'springgreen','lightskyblue','violet','lightsalmon')

it allows you to match a value with a color.

Hope it's useful for you, cheers

[#5]

You could try something like this:

if( myExpresion > 0, red(), rgb(200,155,0))

Where my expression is the actual expression formula

[JonnyPoole]

Since your IF could get pretty big (one nested if for every unique stack) consider some alternatives:

Using 'color by expression' , the following expression assigns 5 specific colors to 5 different years (if years were the stacks)

pick( match(Year, 2009,2010,2011,2012,2013), rgb(255,0,0),rgb(0,255,0),rgb(0,0,255),rgb(255,255,0),rgb(0,255,255))

Or you can put the colors in a table in the  data model with an inline table in the load editor like this. Under 'color by expression' just enter 'color'

Load * Inline [

Year,Color

2009,rgb(255,0,0)

2010,rgb(0,255,0)

2011,rgb(0,0,255)

2012,rgb(255,255,0)

2013,rgb(0,255,255)

];

[#7]

Hi all,

thank you for your replies. I have, however, not been able to fix the problem yet.

I do not want to colour each stack differently, I merely would like to "re-colour" the segments for each stacks:

The simplified underlying data model for the graph looks like the following:

Month	K1	E1	B1	B2	B3	Bx
April	5	4	4	4	3	2
May	3	3	3	2	2	3
June	15	13	12	13	14	12
July	7	8	10	10	9	10
August	6	6	7	7	8	6
September	5	5	4	3	5	5

Hope this makes it clear!

[JonnyPoole · Accepted solution]

Sorry - that was the intent. For my purposes, stacks = segments. 

Here is an example with this expression:

pick(match(Segments,'K1','E1','B1','B2','B3','Bx'),lightred(),lightblue(),LightGreen(),LightGray(),LightMagenta(),yellow())

Using this data load from your table above:

CrossTable(Segments, Values)

LOAD Month,

     K1,

     E1,

     B1,

     B2,

     B3,

     Bx

FROM

[lib://source]

(html, codepage is 1252, embedded labels, table is @1);

[tcullinane]

if all the segments are always going to be present you could just change the appropriate colours in the colour tab in the chart to the ones you want.

If you want specific segments to always be displayed as specific colours then you need the if statement, which is probably best done in a variable.

Here is an example; (I used the vName to define the chart second dimension so it can be changed b the user, hence the multiple options for the colour assignment)

if(match($(vName),'Closed'),RGB(255,248,210),

if(match($(vName),'NA','Resolved'),RGB(255,247,188),

if(match($(vName),'Low','PID Requested','Tier 1','Preventative maintenance'),RGB(254,227,145),

if(match($(vName),'Medium','Open','Tier 2'),RGB(254,196,79),

if(match($(vName),'High','Waiting On A Task','Tier 3','Request For Information'),RGB(254,153,41),

if(match($(vName),'Awaiting User Feedback','Tier 4'),RGB(236,112,40),

if(match($(vName),'Onhold','Incident'),RGB(204,76,2),

if(match($(vName),'Critical','With Vendor'),RGB(153,52,4),

))))))))