Set analysis - average of an average

Wed, 25 Mar 2015 12:38:59 GMT

Hi everyone,

Please could you help

sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"} >}[AB1_ADMIT_LoS])/sum({<[Week Ending]={">=$(VwkEnd)<=$(VwkEndMax)"},[place1 NAME]={"AB1"}>}Admissions)

This is calculating the average time spent in place1 during that week ending.

Now I need to plot the Average expression in my chart. How would I use this average by weekending to aggregate an average expression?
I am new and I am not too clever at writing set analysis just yet.

Thank you in advance.

Re: Set analysis - average of an average

Jacek — Wed, 25 Mar 2015 12:58:22 GMT

Hi Sarah

Can You attach some data? What means [AB1_ADMIT_LoS] and Admissions column? Did You try use AVG function?

TIP: average of averages = sum values of averages / count of averages

topic Re: Set analysis - average of an average in QlikView

Set analysis - average of an average

Re: Set analysis - average of an average