Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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.