Can we colour the Minimum and Maximum value of an expression

[bimala0507]

Dear experts:

I would like to highlight the Maximum and Minimum value of an expression with different colour (RED,GREEN). Will it be achievable in QlikView?

E.g. I have the Expression Average Capacity of a machine for each factory  and I would like to COLOUR GREEN for MAX value and RED for MIN  value.  Is it possible?

Kind Regards,

Bimala

[#2]

Yes it is possible. In the Chart Properties->Expressions. click on the + Icon. You have Background Color, Text Color. There you can specify your conditions and use the appropriate color code in color functions like rgb().

[anbu1984 · Accepted solution]

Try this expr in Text Color of your expr

If(Column(1) = Max(TOTAL Aggr(Avg(Sales),Month)),Green(),If(Column(1)=Min(TOTAL Aggr(Avg(Sales),Month)),Red()))

[bimala0507]

Thx much !! It works fine.