topic How to emphasize the lowest/highest value in a graph in QlikView

How to emphasize the lowest/highest value in a graph

Anonymous — Wed, 26 Jun 2013 20:01:12 GMT

Dear all,

I've a graph, a linear graph, which represents a sort of performance monitor.

Is it possible to underline , emphasize, the lowest value (or high) ?

Thanks in advance

Stefan

skokenes — Wed, 26 Jun 2013 20:29:02 GMT

What I typically do is use the rank() function with a combo chart.

First I write an expression for the line I am graphing:

sum(Expression1)

Then I add separate expressions for the min and the max that are set to be symbols instead of lines. The expression for the max:

if(rank(sum(Expression1))=1,sum(Expression1))

The min would be the inverse of that expression:

if(rank(-sum(Expression1))=1,sum(Expression1))

Finally, I use the Background Color settings available on the expression dropdown to set the min and max to the colors I want. The result:

Anonymous — Thu, 27 Jun 2013 18:02:58 GMT

Hi Speros,

you are the best !!

THANKS!!