Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my Bar Chart all Q3 same color ?

Hi All

Q3 same color.png

1 Solution

Accepted Solutions
robert_mika
Master III
Master III

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)

View solution in original post

4 Replies
robert_mika
Master III
Master III

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
Master
Master
Author

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
Master III
Master III

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
Master
Master
Author

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