topic Average Calculation problem in QlikView

Average Calculation problem

Thu, 27 Mar 2014 14:08:13 GMT

Hi all,

I have a data as per the table below. I am trying to calculate an average and have used sum(cost)/sum(activity). This works fine for the total ie 1000/500 = 2 and for the ward 600/500=1.2.

However, theatre is returning 400/2 = 200 as only 2 patients used the theatre. I would like an average that returns 400/500 = 0.8 as an average cost for all the patients.

Any help gratefully received.

thanks

ian

Cost type

Costtype	Total Cost	Total Activity
Total	1000	500
Ward	600	500
Theatre	400	2

Re: Average Calculation problem

Thu, 27 Mar 2014 14:21:48 GMT

Try this,

Sum(if(costtype='Theatre',Total Cost) / Sum(if(costtype='Ward',Total Activity)

Re: Average Calculation problem

MK_QSL — Thu, 27 Mar 2014 14:25:38 GMT

Try

sum(cost)/sum(TOTAL activity)

sum(cost)/sum({1}activity)

sum(cost)/COUNT(DISTINCT activity)

sum(cost)/sum(DISTINCT activity)

Re: Average Calculation problem

Thu, 27 Mar 2014 14:34:27 GMT

Hi Ian

Try

sum(cost)/sum(Total activity).

best regards