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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Easy Alternate State and Set Analysis?

I have a expression in a textbox which works very well with an Alternate State of [AllTheatres]
=avg(aggr(count(ProcedureCount), Weekstart))

Moving over to Set Analysis, I had expected to be able to limit the set to the Alternate State but a text box with a expression of:

=

avg( {[AllTheatres]} aggr(count(ProcedureCount), Weekstart

))

Gives completely 

differenent results

Any ideas?

Regards,

Stewart

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

you applied state only on the avg

apply it on count as well

View solution in original post

2 Replies
giakoum
Partner - Master II
Partner - Master II

you applied state only on the avg

apply it on count as well

Not applicable
Author

Genius!!