topic Re: Aggr function in QlikView

Aggr function

suvechha_b — Wed, 30 Sep 2015 11:40:19 GMT

How to write the following expression with aggr()

=sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units])

Re: Aggr function

gautik92 — Wed, 30 Sep 2015 11:41:24 GMT

aggr(sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units]),yourfield)

Re: Aggr function

jonathandienst — Wed, 30 Sep 2015 12:04:05 GMT

Why? What are you trying to achieve? And how do you plan to use the expression?

Re: Aggr function

Wed, 30 Sep 2015 13:58:31 GMT

Hi suvechha

try to use

sum(aggr (sum({<Measure = {'ORDERS'}, [Fiscal Year]=, [Fiscal Month]=,[Fiscal Month Year]=, fiscal_key = {">=$(vReportMonthFiscalKey)<=$(vMaxFiscalKey)"}>}[Actual Units]),KEY ))

where the KEY is the dimension you want to make aggr function on.