Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
hi
is there anyone that can help me please.
I think you can do this like so:
avg({$<month={'june'},hourint={"8,9,10"}>}volume)
Hi,
Write aggr(sum(volume)/count(Weekday),Month,Weekday)
HI,
Try this expression
Dimension: Hour
Expression:
Volume - Sum(Volume)
Avg Per day - Sum(Volume)/Count(Distinct DateFieldName)
Regards,
Jagan.
Can you please post your data here