Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with Aggr

Hi,

I can't get my values to match. in the attached, the bottom table totals should match the top table. the top table is by customer and the bottom table has a drill down of various categories and product.

If i don't select anything from the bottom table then i get a total of 49,738,890 but the top table states 44,848,395.

and when i select the drill down in the bottom table, 'xyvj' for example, i get 1,644,720 but the top table states 1,616,856.

I am not sure what is going wrong. can anyone help?

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<Period>}Aggr(If(IsNull($(vForecastSales)), $(vTotalSalestoLastPeriod), $(vAnnualSales)), SubCat, SubCat1, [Item Description], Dim))

View solution in original post

3 Replies
Qrishna
Master
Master

Not able to open your app as i am using a PE of QV.Any alternative?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, thanks for your reply. unfortunately not, you will need a licenced version. thanks anyway.

sunny_talwar

May be this

Sum({<Period>}Aggr(If(IsNull($(vForecastSales)), $(vTotalSalestoLastPeriod), $(vAnnualSales)), SubCat, SubCat1, [Item Description], Dim))