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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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!!