Calculating Mean

[#1]

Hi,

Can somebody please help

YearMonth	Population	CM Tickets	Incident Rate
	2136	533	6.03	Average???
11-03	1050	286	3.27	3.02
11-04	1086	250	2.76	3.02

I have the following table in Qlikview Which calculates the inciden rate based on diving (CM Ticket/Population)*(12 for yearly figure.

I want to be able to have the average showing )which you can see should be 3.02). I can then change the straight table to a chart. I don't want to use the trendline feature here as I plan to calculate upper and lower control limits based on the average.

Please help??

Dave

[#2]

Dave, Not sure i have understood your question. there are functions like Dimensionality(), SecondaryDimensionality().

Check these functions, may help you.

check the attached application also.

- Sridhar

[#3]

Sridhar,

Thank you

Not quite what I want, I need the average (3.02) showing on both months as in the gaph above this will enable me to have an average line in a graph.

Once the average is there I can do some other calculations based on this. Been playing around with variables but can't get it to work.

[pat_agen]

hi,

if you have a straight table with dimension "YearMonth" and expressions like this :

1. sum(Population)

2. sum(cm)

3. (sum(cm)/sum(population))*12              // gives incident rate

4. (sum(total cm)/sum(total population))*12 // gives overall average incident rate

will you get what you want?

[#5]

Pat,

Thank you.

Again does not quite work, I am expecting to get the values 3.01 repeated in Year month 11-03 and 11-04.

[pat_agen]

hi,

this is what I got applying my solution exactly as stated: one dimension, 4 expressions in a straight table.

the overall average repeats on each line

[#7]

Pat,

Any chance you could send me that solution to david.haycock@uk.talaris.com

I am on version 9, still not sure at what point to use the aggr function , this was the answer I was expecting.

Thank you for your help

Dave

[pat_agen]

here it is - hopefully it was what you are looking for.

if it's ok verify the question as answered

[#9]

Pat,

There is no table in the view, just blank!

Dave

[pat_agen · Accepted solution]

my mistake.

here it is again plus your corrected version from your 2nd post.