topic Re: How to make my Bar Chart all Q3 same color ? in App Development

How to make my Bar Chart all Q3 same color ?

paulyeo11 — Thu, 08 Oct 2015 21:11:01 GMT

Hi All

Re: How to make my Bar Chart all Q3 same color ?

robert_mika — Thu, 08 Oct 2015 21:19:36 GMT

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)

Re: How to make my Bar Chart all Q3 same color ?

paulyeo11 — Thu, 08 Oct 2015 21:37:56 GMT

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

Re: How to make my Bar Chart all Q3 same color ?

robert_mika — Thu, 08 Oct 2015 21:41:54 GMT

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.

Re: How to make my Bar Chart all Q3 same color ?

paulyeo11 — Thu, 08 Oct 2015 21:45:16 GMT

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