Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
AngieO2019
Contributor II
Contributor II

Aggr Combinations

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.

Labels (3)
1 Reply
Brett_Bleess
Employee
Employee

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

 

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.