topic Aggr function in QlikView

Aggr function

suvechha_b — Wed, 05 Aug 2015 12:38:48 GMT

How to use aggr function in th following expression

sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount)

Re: Aggr function

sunny_talwar — Wed, 05 Aug 2015 12:40:09 GMT

What exactly is your requirement? Not really sure what to recommend unless we know what you are expecting??

Re: Aggr function

Anonymous — Wed, 05 Aug 2015 12:44:09 GMT

aggr(sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount), yourdimension)

aggr will be performed by the sum using yourdimension

e.g. yourdimension is month

you'll get for each month the sum of Amount

Re: Aggr function

suvechha_b — Wed, 05 Aug 2015 12:51:22 GMT

if I am using three dimension.

Then Hw to write the expression ?

Re: Aggr function

sunny_talwar — Wed, 05 Aug 2015 12:53:25 GMT

List out all of them:

Aggr(sum({$<TranType = {'Budget_$(vAmountType)'},CurrentPer = {1},Fiscal_Year = {$(=max(Fiscal_Year))}>} Amount), Dimension1, Dimension2, Dimension3)

But using this in a straight table with Dimension1, Dimension2, Dimension3 has no benefits, because its already doing the aggregation for you.