How to ignore selection when using Aggr?

[alando]

Hi,

The below formula works when when the user does not make any selection. It shows the average of countries attendance to meetings, for the region Africa and Arab States. How do I ensure that the value does no change if a user selects a country?

avg(aggr(Count({$<COUNTRY=, REGION = {'Africa and Arab States'}, STATUS = {'ATTENDED'}, START_DATE = {">=$(vCurrentYearStart)<=$(vToday)"}>} DISTINCT COUNTRY)
/
Count({$<COUNTRY= , =, REGION= {'Africa and Arab States'}, START_DATE = {">=$(vCurrentYearStart)<=$(vToday)"}>} DISTINCT COUNTRY),MEETING_ID))

Thank you in advance

A

[Or]

Both the external avg() and the aggr() will take set analysis. You'll probably have to use that.

[jyothish8807]

Hi @alando 

With your current expression you have, "COUNTRY" selection done by a user should not impact  the overall values. 

[alando · Accepted solution]

Thank you. The following post provided me with the solution: https://community.qlik.com/t5/QlikView-App-Dev/Ignore-single-filter-in-AGGR-function/td-p/1170508htt...

Issue is resolved