topic Possible to make same quarter same color ? in App Development

Possible to make same quarter same color ?

paulyeo11 — Thu, 24 Mar 2016 12:20:49 GMT

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 — Thu, 24 Mar 2016 12:30:07 GMT

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 — Thu, 24 Mar 2016 21:07:27 GMT

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