topic Highlighting the highest values in a column? in QlikView

Highlighting the highest values in a column?

rohitians — Wed, 19 Nov 2014 06:14:02 GMT

Dear All,

I have a requirement where in i need to highlight the highest values in a column,

is it possible ??

kindly help

Kindly help?

Thanks and Regards,

Rohit Yadav

vinay_hg — Wed, 19 Nov 2014 06:22:17 GMT

in the Expression -->

background color expression.. write an expression like

if(max(expression), rgb(0,255,0))

anbu1984 — Wed, 19 Nov 2014 06:25:50 GMT

Check this

sujeetsingh — Wed, 19 Nov 2014 06:28:10 GMT

Rohit,

Expressions have Attributes as shown in Vinay's screenshot image.

Use Text Colour attribute and write down the condition you want

For example

If(sum(Sales)>=500,LightGreen())

This will colour all 500 and greater values to light green colour

ashwanin — Wed, 19 Nov 2014 06:29:20 GMT

Go to Expression -->Click on + sign --> Text -->Definition (add formula)

ie if(max(expression), rgb(0,255,0))

rohitians — Wed, 19 Nov 2014 07:42:00 GMT

Hey,

I did the same i used rank function instead

Thanks for your help..

Thanks and Regards,

Rohit