Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Partner
Partner

Can we colour the Minimum and Maximum value of an expression

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

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Can we colour the Minimum and Maximum value of an expression

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()))

View solution in original post

3 Replies
Not applicable

Re: Can we colour the Minimum and Maximum value of an expression

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
Honored Contributor III

Re: Can we colour the Minimum and Maximum value of an expression

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()))

View solution in original post

Partner
Partner

Re: Can we colour the Minimum and Maximum value of an expression

Thx much !! It works fine.