topic Total of aggregated master measure in App Development

Total of aggregated master measure

NoahF — Thu, 27 Mar 2025 22:38:29 GMT

I have the following master measure, called "Price-effect"

sum(aggr([Preis Δ] * [Menge (V1)] , Item, Werk))

As you can see, Preis Δ and Menge (V1) are both master measures themselves which include aggregations and other master measures (which also include aggregations and other master measures...).

Now I am wondering if I can get my total sum of this master measure "Price-effect", excluding my selections (except for the field "Month").
I have tried using Total and {1} but both do not seem to work.
I suppose the aggregations of the various nested master measures included in [Preis Δ] and [Menge (V1)] are not affected by my set analysis or total.

Is there any way to solve this problem?

Re: Total of aggregated master measure

Chanty4u — Fri, 28 Mar 2025 09:08:10 GMT

Try this

Sum({<Month=P(), Item=, Werk=, OtherFields= >} Aggr([Preis Δ] * [Menge (V1)], Item, Werk))

Re: Total of aggregated master measure

NoahF — Fri, 28 Mar 2025 12:22:30 GMT

Thank you @Chanty4u for your suggestion.

Unfortunately this also doesn't get rid of my selection.

Somehow I am fearing that Qlik calculates the value of the used master measures first, aggregated on my selection and then only passes the aggregated table based on the selection up to this expression.

Can anyone confirm or deny this?