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: 
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