# New to QlikView

Discussion board where members can get started with QlikView.

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
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

## 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.