Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Stars
Creator
Creator

Nested Aggr and Locked Set Analysis Issue

I have a filter set for Company = A.

When I have this expression as my KPI, the result is 36.  Which is perfect.

(Avg({$<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(
Sum({1<Question={"Statistics*"}>}Response)
,Company,Year)))

 

I want to use this in another equation.  But when I nest it, something is wrong....

This, where I type in 36, yields exactly what I want. 

=(count({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(((if(
Sum({1<Question={"Statistics*"}>}Response)>

36,

Sum({1<Question={"Statistics*"}>}Response)
,Null()))),Company,Year)))

 

But when I try to put my other equation in there for the 36, it doesn't work.

What am I doing wrong? 

=(count({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(((if(
Sum({1<Question={"Statistics*"}>}Response)>

(Avg({$<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(
Sum({1<Question={"Statistics*"}>}Response)
,Company,Year))),

Sum({1<Question={"Statistics*"}>}Response)
,Null()))),Company,Year)))

 

Thank you!

 

 

0 Replies