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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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)