Aggr Combinations

AngieO2019 — Sat, 16 Nov 2024 19:04:55 GMT

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.

Re: Aggr Combinations

Brett_Bleess — Wed, 25 Mar 2020 13:47:13 GMT

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

topic Aggr Combinations in QlikView

Aggr Combinations

Re: Aggr Combinations