Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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?
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?
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
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.
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