
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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().

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thx much !! It works fine.
