topic Max Value with Time Intervals in QlikView

Max Value with Time Intervals

Mon, 01 Sep 2014 12:07:44 GMT

Hi guys im find something that should be fairly straightforward to be causing some issues.

I am trying to get the max value of a sum of a time interval from the following table.

Category	sum(TimeTaken)
A	55:50:00
B	2:22:00
C	18:00:00
D	4:26:00
E	0:58:00
F	451:56:00
G	7:19:00
H	35:39:00
I	28:45:00
J	23:28:00
K	6:12:00
L	61:13:00
M	28:27:00
N	0:40:00

The value im expecting should be 451:56:00.

What I want to achieve is to set a "Static Max" value of a Y axis on a Chart table, reason is that I have one chart over the other, one of the charts is transparent and the user changes and filters values the Chart moves around on the max values.

So With this I would hope that I always have both charts showing the max possible value and thus they are always showing correct values.

Many Thanks

Re: Max Value with Time Intervals

tresB — Mon, 01 Sep 2014 12:14:42 GMT

Try like:

=Max(Aggr(sum({1}TimeTaken),Category)) // {1} makes it selection irrespective thus making it static.

Re: Max Value with Time Intervals

Mon, 01 Sep 2014 12:37:31 GMT

That does work, but the problem is now that if the user selects 2 or 3 months the chart bars become very small due to the scale of the whole chart.

Strangely if I replace the ignore selections os the set analysis with a $ it does not give me the correct value for my selections.

Confused.

Re: Max Value with Time Intervals

Tue, 02 Sep 2014 10:11:21 GMT

Ok it was under my nose all along, the correct is

=interval(max(aggr(sum(interval(TimeTaken,'hh:mm')), Category)),'hh:mm')