Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mikecrengland
Creator III
Creator III

Highlight largest & smallest values in bar chart

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.

issues.PNG issues2.PNG

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

13 Replies
MarcoWedel

can you post a sample app?

regards

Marco

MarcoWedel

mikecrengland
Creator III
Creator III
Author

Hi Marco -

App attached...

Thanks for the help!

mikecrengland
Creator III
Creator III
Author

Unfortunately, this one didn't work.

mike

Not applicable

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
Creator III
Creator III
Author

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

Not applicable

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
Creator III
Creator III
Author

Hi Rakesh -

Attached.

Thanks for the help!

Not applicable

which graph