topic Re: Average per interval per day name in QlikView

Average per interval per day name

Mon, 29 Jun 2015 11:21:11 GMT

Hallo

please could some one help me. I am so stuck and very new to qlikview.

I have a table showing volumes per interval (hour) for June month per weekday (i.e Mon, tues, wed etc). I know what to know on average for the month of June how many volumes I received on a Mon, Tue, Wed etc. In example below June month got 4 Fridays therefore on Fridays we receive on average 29 calls between 8 and 9 and on average 44 calls between 9 and 10.

how do I write it in my expression field.

thank you very much

June	Friday
Hour_Int	volume	Ave per day
8	114	28.50
9	175	43.75
10	139	34.75
11	128	32.00
12	129	32.25
13	116	29.00
14	134	33.50
15	126	31.50
16	35	8.75
17	18	4.50
18	7	1.75

Total	1 121	280.25

Re: Average per interval per day name

Thu, 02 Jul 2015 04:32:40 GMT

is there anyone that can help me please.

Re: Average per interval per day name

ikarimov — Thu, 02 Jul 2015 04:48:38 GMT

I think you can do this like so:

Re: Average per interval per day name

pratap6699 — Thu, 02 Jul 2015 06:32:58 GMT

avg({$<month={'june'},hourint={"8,9,10"}>}volume)

Re: Average per interval per day name

timanshu — Thu, 02 Jul 2015 07:04:29 GMT

Hi,

Write aggr(sum(volume)/count(Weekday),Month,Weekday)

Re: Average per interval per day name

jagan — Thu, 02 Jul 2015 07:46:42 GMT

HI,

Try this expression

Dimension: Hour

Expression:

Volume - Sum(Volume)

Avg Per day - Sum(Volume)/Count(Distinct DateFieldName)

Regards,

Jagan.

Re: Average per interval per day name

sasiparupudi1 — Thu, 02 Jul 2015 14:07:43 GMT

Can you please post your data here