Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
Sum({<Month=P(), Item=, Werk=, OtherFields= >} Aggr([Preis Δ] * [Menge (V1)], Item, Werk))
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?