topic Displaying Min & Max with a Reference Line in QlikView

Displaying Min & Max with a Reference Line

Mon, 29 Mar 2010 12:50:01 GMT

Hi there,
I am trying to add 2 references lines to a chart which displays a count overtime. I would like to add the Max and Min values of the current selection with reference lines. In the expression I have RangeMin($) and RangeMax($). I assumed the $ would be the current selected data but it displays 0. I have tried RangeMax(count(varname)) which is used for the main graph but this does not display anything.

I can't find any obvious help in the reference manual. Any help would be greatly appreciated.

Thanks

Andrew

Displaying Min & Max with a Reference Line

johnw — Mon, 29 Mar 2010 20:06:50 GMT

I believe you want this:

min(aggr(your overtime expression,your first dimension,your second dimensions,...))
max(aggr(your overtime expression,your first dimension,your second dimensions,...))

For example, if your expression is sum(Quantity), and your chart dimensions are Year and Customer:

min(aggr(sum(Quantity),Year,Customer))
max(aggr(sum(Quantity),Year,Customer))

Displaying Min & Max with a Reference Line

Mon, 29 Mar 2010 21:01:37 GMT

Hi John,

Thanks for replying.

I am using a Group Drill Down for the other dimension.

=Date(MakeDate(EventYear),'YYYY')
=Date(MakeDate(EventYear,EventMonth),'MMM')
=Date(MakeDate(EventYear,EventMonth,EventDay),'dd')
=Time(MakeTime(EventHour),'HH')
=Time(MakeTime(EventHour,EventMinute),'mm')

What would I enter for the Drill Down Dimension?

Thanks

Displaying Min & Max with a Reference Line

johnw — Mon, 29 Mar 2010 21:15:56 GMT

Well, I don't think I've done it with a drill down group before. My GUESS is that you'd enter the name of the drill down group. So if the drill down group is named "Date and Time Group", I'm guessing:

min(aggr(count(varname),"Date and Time Group"))

Displaying Min & Max with a Reference Line

Mon, 29 Mar 2010 21:35:18 GMT

Hi John,

That doesn't appear to work.

Here what I entered. Where Tag_Count_Drill_Down is my Group.

min(aggr(Count(Tag),"Tag_Count_Drill_Down"))

Displaying Min & Max with a Reference Line

johnw — Mon, 29 Mar 2010 21:46:53 GMT

Here's a working example of what I think you're asking for.

Displaying Min & Max with a Reference Line

Mon, 29 Mar 2010 22:02:39 GMT

Hi John,
It's the expression I had in the group. Works fine with EventYear........

Thanks for the excellent support.

Cheers
Andrew

Displaying Min & Max with a Reference Line

ob — Fri, 18 Jun 2010 10:58:40 GMT

This was a great help for me! I struggled to find the maximum value in a line chart to be able to decide the Y-axis value when using a Reference line. Thanks!