Aggr Combinations

[AngieO2019]

Hi All,

We are trying to create a 'Potential Savings calculator' report for Cat cafes. The formula that we are using in QlikView:

(Avg(Aggr(SUM([Spend]) / Sum([Cat Population]), [Cat Breed], City)) * [Cost Standard Multiplier])) - (SUM([Spend]) / Sum([Cat Population])

However, this formula brings a blank or rather empty pivot table in QlikView.

Attached is a sample data that we made in Excel to further help/explain the expected results of the issue.

[Brett_Bleess]

Without example QVW, going to be difficult for folks to help much.  Best I can do for you otherwise would to check out the Design Blog area, here is a specific post and the base URL after that you can use to search further on your own.

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett