Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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