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