topic Re: AGGR Function in QlikView

AGGR Function

Wed, 25 Nov 2020 16:16:04 GMT

I want to create the dynamic aggr expression for a group dimension using dollar expression.

Plz do the needful

thnx in advance

Regards,

Qliker

sunny_talwar — Fri, 03 Jun 2016 13:46:46 GMT

Would you be able to provide more details? What is the group name, what is the expression... etc?

narendiran — Fri, 03 Jun 2016 14:09:23 GMT

Hi Abhishek,

Please follow the below steps to do dynamic aggr

In Document Properties | Groups, create a group called Cycle1 with ProdID and Month as the dimensions:
Edit the straight table and add Cycle1 as the second dimension.
Save the changes and look at the chart. Note that the expressions do not calculate correctly for all the different cycle values.

Open the properties of the table and edit the Sales $ expression:

Sum( AGGR(Sum(Price*Qty)/ExRate, Country, [$(=GetCurrentField(Cycle1))]) )

Kushal_Chawda — Fri, 03 Jun 2016 14:19:18 GMT

Just create cyclic group

further you can dynamically use the Aggr with cyclic group like in below thread

akpofureenughwu — Fri, 03 Jun 2016 14:21:18 GMT

Sahal.. Please for clarity sake, help us with some details. Cheers

Mon, 06 Jun 2016 06:44:23 GMT

i Have created the cyclic group(Group1) with two dimensions(curr,vol)

and m using this expressiion

sum(AGGR(sum(Price*qty)/ExRate, Country, [$(=GetCurrentField(Group1))]))

And m getting the value only for currency field not for volume.

Thanks to all for giving the appriciated efforts.

Regards,

Qliker.

swuehl — Mon, 06 Jun 2016 07:41:40 GMT

When using volume as dimension, you probably don't have a unique ExRate per dimension value, so you need to use an aggregation function:

sum(AGGR(sum(Price*qty)/Avg(ExRate), Country, [$(=GetCurrentField(Group1))]))

sum(AGGR(sum(Price*qty/ExRate), Country, [$(=GetCurrentField(Group1))]))

or any other appropriate aggregation.