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