topic Highlighting Min and Max on the Line chart in QlikView

Highlighting Min and Max on the Line chart

vlad_komarov — Fri, 25 Feb 2011 17:58:36 GMT

I may be missing something, but I was not able to find an option to highlight the Min and Max value on regular Line Chart. It exists by default on Mini Chart (attached), but I would need to do the same presentation on the regular chart as well.

Any suggestions?

Best regards,

Vladimir

Highlighting Min and Max on the Line chart

Fri, 25 Feb 2011 19:59:16 GMT

you could use reference lines to indicate the maximum and minimum

Highlighting Min and Max on the Line chart

johnw — Fri, 25 Feb 2011 20:14:33 GMT

You're not missing anything. So far as I know, it isn't directly supported, so you'll have to fake it.

Add extra expressions for the min and max, defined such that the value is only non-null when at the min or max. Using rank() seems simpler than checking for min and max directly, though. Display these new expressions as symbols instead of lines. See attached file and example expressions below:

if(rank(-sum(F2))=1,sum(F2)) // min value
if(rank( sum(F2))=1,sum(F2)) // max value

Re:Highlighting Min and Max on the Line chart

vlad_komarov — Fri, 25 Feb 2011 20:21:41 GMT

Yes, it might work for one line charts, but I can have up to 10 lines in there, so it will not look too good....

Highlighting Min and Max on the Line chart

vlad_komarov — Fri, 25 Feb 2011 22:56:58 GMT

John,

As always, clear and simple!

Exactly what I've asked for.

Thanks!

Regards,

Vladimir

Highlighting Min and Max on the Line chart

johnw — Fri, 25 Feb 2011 23:07:36 GMT

Except that my solution won't work well when you have multiple lines. Or does it? I assumed you meant you had a second dimension, and line charts pretty much allow for two dimensions or multiple expressions, but not both. So using extra expressions to highlight the min and max doesn't seem like it would work in that case. Or maybe it does in v10? Or maybe I'm just wrong?

Highlighting Min and Max on the Line chart

vlad_komarov — Sat, 26 Feb 2011 01:37:04 GMT

John,

I can live with one dimension for this exercise, so your solution works perfectly for multiple lines. The only issue so far is to sync colors for all line's symbols, but it's manageable .

I will upload a modified sample for the record shortly.

Thanks!
Regards,
Vladimir

Highlighting Min and Max on the Line chart

johnw — Sat, 26 Feb 2011 01:44:50 GMT

One thing that may help with synchronizing the colors is to use background color expressions instead of the default chart colors. I almost did that in the example, but for a single line, it seemed easier to just put the colors on the Colors tab.

Edit: I thought of a simplification. If your line has a label of 'Y', then the other expressions can refer to that label instead of repeating the expression:

if(rank(-Y)=1,Y)
if(rank( Y)=1,Y)

Won't matter much for something as simple as sum(F2) like in the example, but may simplify real world problems quite a bit.

Highlighting Min and Max on the Line chart

vlad_komarov — Sat, 26 Feb 2011 08:21:46 GMT

Thanks, John.

Here is the updated example with your original code but for multiple lines and synchronized colors.

Thanks again for your help.

Regards,

Highlighting Min and Max on the Line chart

Mon, 04 Jul 2011 05:49:27 GMT

what u will do in case, the dimension has values more than 10,lets say upto 100....i think in that case it will not be appropriate to use this max & min

Highlighting Min and Max on the Line chart

vlad_komarov — Wed, 10 Aug 2011 22:15:10 GMT

I do not have any problem with 100 and over number of points on the chart. Both Min and Max are displayed.

What kind of issues do you have?

Regards,

Re: Highlighting Min and Max on the Line chart

Fri, 29 Jun 2012 14:40:21 GMT

Hi,

OK trying a real world example with a horrendously long Aggr expression and toggle between charts states I had, I thought I'd try this to simplify later understandability of my particular expression.

Copying the entire formula into your Rank expression works a treat, however using the simplified approach of the label doesnt work for me. Can you share a worked example. e.g. if I just try the same idea with the QVW example in this thread and adapt it by labelling the line as LineName, I did this which isnt working. What am I missing? Thanks

Also not sure if its a curveball but in my realworld application my toggle state label names have a space between them - e.g. they look like 'Line Name' so would this be an issue, if so is there a workaround to support multiple word label names.

Re: Highlighting Min and Max on the Line chart

natebrunner — Mon, 23 Jul 2012 19:09:52 GMT

How can you pull this off if you have 2 dimensions, such as Provider and Reporting Period, and then just 1 expression? I'd like to show the min and max dots for each provider over the time period I have selected

Re: Highlighting Min and Max on the Line chart

prees959 — Fri, 26 Oct 2018 11:38:21 GMT

Hi John

This is a great solution which is working for me. Is it possible to plot the data values along with the Max and Min symbols?

Phil