Highlight largest & smallest values in bar chart

[mikecrengland]

Hello All -

I'm stuck...

I have a bar chart where I would like to highlight the largest and smallest values in red and green. I'm using the following in the Background Color:

IF(Rank([Issues by Month]) = 1, $(vRed),

IF(Rank (-[Issues by Month]) = 1, $(vDarkGreen),

ARGB(100,192,192,192)))

[Issues by Month] is the expression name for count(DISTINCT Issues.Key)

The problem is that I have dates and other data in the app that are before any recorded issues. The smallest value for the expression is Null and out of range of the chart, so it never gets highlighted; if I filter down to months where there are values, it works fine.

I've been trying everything that I can think of, and I'm stumped. How do I limit the background color to a beginning date?

Thanks in advance,

mike

[MarcoWedel]

can you post a sample app?

regards

Marco

[MarcoWedel]

maybe this helps?

http://community.qlik.com/message/664515#664515

regards

Marco

[mikecrengland]

Hi Marco -

App attached...

Thanks for the help!

[mikecrengland]

Unfortunately, this one didn't work.

mike

[#6]

Hi Mike,

Try this...

IF(Rank(-SUM([Issues by Month]))= 1, RGB(255,0,0),
IF(Rank(SUM([Issues by Month]))= 1, RGB(10,255,30)))

Regards,

Rakesh

[mikecrengland]

Thanks Rakesh, but still no luck. I think on this because [Issues by Month] is actually the name of the expression and not a field name.

mike

[#8]

Mike

yes, there should be field name

if you don't mind could you please send me the original file so I can work on that and send back to you.

[mikecrengland]

Hi Rakesh -

Attached.

Thanks for the help!

[#10]

which graph