Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

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
gautik92
Specialist III
Specialist III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

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.