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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Stanislav1
Contributor III
Contributor III

Set analysis with master measure

Good afternoon!

I saw multiple posts of how can I reuse master measure, but it doesn't work in my case. I tried with using variables and then referencing the variable, but still doesn't work. My expression is simple. 

 

I have master measure:  msr171 (Period), it is a big measure using SUM as aggregating function 

$(vL.AdsCostAPA) is a variable which golds the value of msr171 (Period)

I want to use set analysis to further narrow down to Ad Network = 'Apple Search Ads'

I am trying to do the following:  ONLY({<[Ad Network]={"Apple Search Ads"}>} $(vL.AdsCostAPA))

However, I get the error "Nested aggregation not allowed". How can I get around it?

Labels (3)
1 Solution

Accepted Solutions
Clement15
Partner - Specialist
Partner - Specialist

Hello,

$(vL.AdsCostAPA) has a structure like sum(Measure) ? You can't do only(sum(...)). If your goal is just to add the set analysis you can use this:

={<[Ad Network]={"Apple Search Ads"}>}$(vL.AdsCostAPA)

View solution in original post

1 Reply
Clement15
Partner - Specialist
Partner - Specialist

Hello,

$(vL.AdsCostAPA) has a structure like sum(Measure) ? You can't do only(sum(...)). If your goal is just to add the set analysis you can use this:

={<[Ad Network]={"Apple Search Ads"}>}$(vL.AdsCostAPA)