median on half hour

[#1]

Dear all

I'm trying to find an expression for the following.

I need a median on Air Traffic per half hour times 2 per day. Example:

Time	Median
09:00 - 10:00	4
10:00 - 11:00	8
11:00 - 12:00	12
12:00 - 13:00	1
13:00 - 14:00	2
14:00 - 15:00	3
15:00 - 16:00	15
16:00 - 17:00	5
17:00 - 18:00	5
18:00 - 19:00	4
19:00	14

My expression should be setup in that way that the result would be just "3". It works fine in a table when displaying the total, but it wouldn't work in a textbox....

Someone can help?

Tanks and Cheers

Benny

[sunny_talwar]

I need a median on Air Traffic per half hour times 2 per day. Example:

I am not sure I understand this. Can you elaborate?

[#3]

Hi Sunny

My current expression, which works, is as follows:

median(aggr(sum({<TimeInMinutes={[30]}, Runway={[14]}>}if(TimeOfArrival>=TimeFromMinutes AND TimeOfArrival < TimeToMinutes, NoOfFlights)),TimeHHMM))

TimeFromMinutes is like 09:00 o'clock * 60 Minutes = 540

TimeToMinutes ist like 10:00 o'clock * 60 = 600

The result is like the table above. But the result what I really need is just the median of the table ( 3 ), so that if I setup a textbox and enter the expression Qlikview would just show me the median of all sums of flights for one day per half hour.... A bit complicated, isn't it?

Thanks and regards

Benny

[sunny_talwar]

Would you be able to share sample row of datas for all the columns you are using in your expression? I would like to replicate your issue at my end.