topic Average calculations in QlikView

Average calculations

Fri, 09 Aug 2013 12:59:33 GMT

Hi,

I am trying to work out an average of a sum. Can anyone help? The calculation shows a percentage of utilisation.

= (sum(total_anaesthetic_time ) + sum(total_theatre_time)) / sum (total_scheduled_mins)

Does anyone know how I would get an average for this? I need it so I can break it down to specialty level and freeze the graph at this average when the user drills down further to consultant etc..

Thanks,

Re: Average calculations

Fri, 09 Aug 2013 13:04:45 GMT

try this

= (sum(total_anaesthetic_time + total_theatre_time)) / sum (total_scheduled_mins)

or try this

= (sum(time(total_anaesthetic_time) + time(total_theatre_time))) / sum (time(total_scheduled_mins))

or try this

= (sum(time(total_anaesthetic_time,'hh:mm') + time(total_theatre_time,'hh:mm'))) / sum (time(total_scheduled_mins,'hh:mm'))

or try this simply

= (time(total_anaesthetic_time,'hh:mm') + time(total_theatre_time,'hh:mm')) / time(total_scheduled_mins,'hh:mm')

Re: Average calculations

Fri, 09 Aug 2013 13:11:33 GMT

for find the average sum of two field then try this

sum(field1 + field2)/count(field1)

or this

(sum(field1) +sum( field2))/count(field1)

Re: Average calculations

hic — Sat, 10 Aug 2013 19:07:13 GMT

If you want the average pecentage, you probably need an Aggr() function. See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

HIC