Possible to make same quarter same color ?

[paulyeo11]

Hi All

I have a Bar chart by Quarterly.

It is possible to make the Q1 for every same color ?

So that i can see the sales trend by Qtr.

Paul

[MK_QSL]

Go to Chart Appearance

Colors and Legend

Write below expression

IF(WildMatch(YearQtr,'Q1*'),Green(),

IF(WildMatch(YearQtr,'Q2*'),Red(),

IF(WildMatch(YearQtr,'Q3*'),Yellow(),

IF(WildMatch(YearQtr,'Q4*'),QlikTechGray()))))

[paulyeo11]

Hi Sir

Thank you very much.

I notice that for sales by month , i don't require any script to make the color for every Jan same color, ( Chart 1 )

So it is possible combine the 2 chart into 1 ? So that month and Quarter will have same color.

Paul