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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NoahF
Contributor III
Contributor III

Total of aggregated master measure

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

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

NoahF_0-1743114650726.png

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?

Labels (2)
2 Replies
Chanty4u
MVP
MVP

Try this 

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

 

NoahF
Contributor III
Contributor III
Author

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?