topic Re: Aggr calculation in QlikView

Aggr calculation

tmumaw — Sat, 16 Nov 2024 03:56:01 GMT

I'm having a small issue when trying to do a Aggr sum. Here is my formula and example. Does anyone see why it would only populate the Midwest East and not New England & SE? Here is my formula: aggr(Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1),FISYR)

Re: Aggr calculation

marcus_sommer — Fri, 05 Apr 2019 15:04:52 GMT

Try it in this way:

sum(aggr(Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1),FISYR, GM))

- Marcus

Re: Aggr calculation

tmumaw — Fri, 05 Apr 2019 15:08:56 GMT

Nope. My Gross Sales = Service Line with that calculation. The top numbers are correct, just can't figure out why they won't duplication for New England & SE

Re: Aggr calculation

sunny_talwar — Fri, 05 Apr 2019 16:45:07 GMT

Try this

Aggr(NODISTINCT Sum({<Level2=,Level3=,Level4=,[PC Desc]=,[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1), FISYR)

Re: Aggr calculation

tmumaw — Fri, 05 Apr 2019 17:11:41 GMT

Thanks Sunny. It took care of my issue.