A quick question

Thu, 20 Mar 2014 09:53:14 GMT

i worked out a table like below by each timepoint, the expression is "

(

sum(aggr(if(Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)
/
Sum({$<PLAvailability_ClassStatusCode={'Booked', 'Assigned', 'Finished'},PLAvailability_1dayflag={'1'}>}PLAvailability_ClassCount)<>1,1,0),PLAvailability_TimeSlot,PLAvailability_InsertDate)))
/
24

LodingTime	DAY1 % of Available Slot
1/2/2014 0:02	4.20%
1/4/2014 18:02	4.20%
1/6/2014 12:02	4.20%
1/6/2014 18:02	4.20%
1/7/2014 6:02	4.20%
1/7/2014 12:02	4.20%
1/8/2014 6:02	4.20%
1/8/2014 18:02	4.20%
1/9/2014 0:02	4.20%
1/9/2014 6:02	4.20%
1/10/2014 0:02	4.20%
1/13/2014 0:02	4.20%
1/13/2014 6:02	4.20%
1/14/2014 6:02	4.20%

now i want to show the average number by year month

YearMonth	LodingTime	DAY1 % of Available Slot
201401	1/2/2014 0:02	4.20%
	1/4/2014 18:02	4.20%
	1/6/2014 12:02	4.20%
	1/6/2014 18:02	4.20%
	1/7/2014 6:02	4.20%
	1/7/2014 12:02	4.20%
	1/8/2014 6:02	4.20%
	1/8/2014 18:02	4.20%
	1/9/2014 0:02	4.20%
	1/9/2014 6:02	4.20%
	1/10/2014 0:02	4.20%
	1/13/2014 0:02	4.20%
	1/13/2014 6:02	4.20%
	1/14/2014 6:02	4.20%
	1/15/2014 6:02	8.30%
	1/16/2014 0:02	4.20%
	1/16/2014 6:02	4.20%
	1/17/2014 6:02	4.20%
	1/17/2014 18:02	8.30%
	1/18/2014 0:02	4.20%
	1/19/2014 6:02	4.20%
	1/19/2014 12:02	4.20%
	1/21/2014 6:02	4.20%
	1/22/2014 0:02	4.20%
	1/23/2014 6:02	4.20%
	1/25/2014 0:02	4.20%
	1/26/2014 6:02	4.20%
	1/26/2014 12:02	4.20%
	1/27/2014 6:02	8.30%
	1/28/2014 6:02	4.20%
	1/29/2014 6:02	4.20%
Total		141.70%

i just want to Total to be the average of those numbers , how can i do that?

Re: A quick question

Thu, 20 Mar 2014 09:58:20 GMT

what i mean it is currently giving me the total, i want to average

Re: A quick question

PrashantSangle — Thu, 20 Mar 2014 09:59:22 GMT

Hi,

In Expression tab->total Mode->Select (Sum )of Rows

Expression tab->total Mode->Select (Avg )of Rows

Re: A quick question

Thu, 20 Mar 2014 10:08:56 GMT

it just greyed out, can not choose it

Re: A quick question

PrashantSangle — Thu, 20 Mar 2014 10:18:26 GMT

Hi,

I am considering that you are using Straight table

regards,

Re: A quick question

Thu, 20 Mar 2014 10:23:37 GMT

It seems you are using a Pivot Table. Convert it to a Straight Table and the option should be available to you.

Rgds,

topic Re: A quick question in QlikView

A quick question

Re: A quick question

Re: A quick question

Re: A quick question

Re: A quick question

Re: A quick question