Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - average of an average

    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.

1 Reply
Jacek
Creator
Creator

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