topic Re: Help with Aggr in QlikView

Help with Aggr

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Help with Aggr

Qrishna — Tue, 01 May 2018 16:14:32 GMT

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

Re: Help with Aggr

hopkinsc — Tue, 01 May 2018 16:16:16 GMT

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

Re: Help with Aggr

sunny_talwar — Tue, 01 May 2018 16:31:50 GMT

May be this

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