topic Re: How to ignore selection when using Aggr? in App Development

How to ignore selection when using Aggr?

alando — Thu, 30 Sep 2021 13:00:19 GMT

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

Re: How to ignore selection when using Aggr?

Or — Thu, 30 Sep 2021 13:03:27 GMT

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

Re: How to ignore selection when using Aggr?

jyothish8807 — Thu, 30 Sep 2021 13:15:21 GMT

Hi @alando

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

Re: How to ignore selection when using Aggr?

alando — Thu, 30 Sep 2021 13:25:59 GMT

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/1170508https://community.qlik.com/t5/New-to-Qlik-Sense/Ignore-a-Filter-Selection-in-a-Aggregate-Function-with-Set/td-p/1612455

Issue is resolved