Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

suvechha_b
Contributor II

Aggr function

How to write the following expression with aggr()

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

3 Replies
Highlighted
gautik92
Valued Contributor III

Re: Aggr function

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

MVP
MVP

Re: Aggr function

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Aggr function

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.