Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to make my Bar Chart all Q3 same color ?

Hi All

Q3 same color.png

1 Solution

Accepted Solutions

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

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)

4 Replies

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

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
Valued Contributor II

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

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 ?

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
Valued Contributor II

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

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