Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

Possible to make same quarter same color ?

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

2 Replies

Re: Possible to make same quarter same color ?

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

Re: Possible to make same quarter same color ?

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

Community Browser