topic Aggr in QlikView

Aggr

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

Hi Community,

Can I have alternate calculated dimension with aggr or with any other function as I am not getting all IRB_Band values

aggr(aggr(only({<%Month = {'$(=$(=vCurrMonth))'},%Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB_Band),IRB_Band),INVOLVED_PARTY_ID)

Re: Aggr

jonathandienst — Sat, 09 Apr 2016 14:41:18 GMT

If you need a calculated dimension for IRB_Band, then this should be enough:

aggr(only({<%Month = {'$(=$(=vCurrMonth))'},%Year = {'$(=$(=vCurrYear))'},CURRENCY = {'$(=$(vCurr))'}>}IRB_Band),IRB_Band)

or better:

aggr(only({<%Month = {'$(vCurrMonth)'},%Year = {'$(vCurrYear)'},CURRENCY = {'$(vCurr)'}>} IRB_Band), IRB_Band)

I am not sure why you believe that a nested Aggr() is required. Perhaps you could provide a lot more information about your data model, or better still a sample illustrating the problem.

Re: Aggr

sunny_talwar — Sat, 09 Apr 2016 14:45:05 GMT

What do you mean alternate calculated dimension? Are you wanting to use alternate state? May be move the whole chart to another state if that's what you are looking for.