topic Re: Highlight largest & smallest values in bar chart in QlikView

Highlight largest & smallest values in bar chart

mikecrengland — Wed, 14 Jan 2015 21:25:42 GMT

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

Re: Highlight largest & smallest values in bar chart

MarcoWedel — Wed, 14 Jan 2015 22:58:32 GMT

can you post a sample app?

regards

Marco

Re: Highlight largest & smallest values in bar chart

MarcoWedel — Wed, 14 Jan 2015 23:02:51 GMT

maybe this helps?

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

regards

Marco

Re: Highlight largest & smallest values in bar chart

mikecrengland — Wed, 14 Jan 2015 23:50:00 GMT

Hi Marco -

App attached...

Thanks for the help!

Re: Highlight largest & smallest values in bar chart

mikecrengland — Thu, 15 Jan 2015 17:08:19 GMT

Unfortunately, this one didn't work.

mike

Re: Highlight largest & smallest values in bar chart

Thu, 15 Jan 2015 17:40:08 GMT

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

Re: Highlight largest & smallest values in bar chart

mikecrengland — Thu, 15 Jan 2015 18:09:07 GMT

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

Re: Highlight largest & smallest values in bar chart

Thu, 15 Jan 2015 18:12:58 GMT

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.

Re: Highlight largest & smallest values in bar chart

mikecrengland — Thu, 15 Jan 2015 18:14:36 GMT

Hi Rakesh -

Attached.

Thanks for the help!

Re: Highlight largest & smallest values in bar chart

Thu, 15 Jan 2015 18:16:51 GMT

which graph

Re: Highlight largest & smallest values in bar chart

mikecrengland — Thu, 15 Jan 2015 18:17:31 GMT

Top right, the one labeled Issues by Month

Re: Highlight largest & smallest values in bar chart

Thu, 15 Jan 2015 18:25:28 GMT

Mike,

Please find the attachment...

min value is not working because you do not have data for aug and sep please provide some data for these then it'll work.

max is working...

Re: Highlight largest & smallest values in bar chart

mikecrengland — Thu, 15 Jan 2015 18:29:29 GMT

Yup, that was my original problem. Unfortunately, there isn't any data for the first two months.

Re: Highlight largest & smallest values in bar chart

Thu, 15 Jan 2015 18:33:21 GMT

yes,

because, before sending you, I tried the same formula and it is working