Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Both the external avg() and the aggr() will take set analysis. You'll probably have to use that.
Hi @alando
With your current expression you have, "COUNTRY" selection done by a user should not impact the overall values.
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