How to make my Bar Chart all Q3 same color ?

[paulyeo11]

Hi All

[robert_mika · Accepted solution]

Colors and Legend

Colors

Custom

By Expression

Your Expression is

if(left(YearQtr,2)='Q3',Red(),Green())

Or you can play with RGB() function

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[paulyeo11]

Hi Robert

Many thank for the expression , it work fine. My though is to have all Q1 and Q2 and  Q3 and Q4 having individual color , but after using your expression , i find it better just make Q4 one color and the rest one color. This way more easy to view the trend , for example i am focus on forecast Q4 sales for 2015 , which is next Qtr.

So some time it is base on luck that we find right expression.

Thank a lot.

Paul

[robert_mika]

Glad it work for you.

I hope that at one point-probably in version 11 of QS we will be able to choose colors with less technical method.

[paulyeo11]

Hi Robert

QS ver 11 , now is ver 2 , if every year 1 version up , it will take 11 year , by that time i will be 71 year old. Hope i am still around

Paul