topic Latest Month: Set Analysis (Issue# Nested aggregation not allowed) in QlikView https://community.qlik.com/t5/QlikView/Latest-Month-Set-Analysis-Issue-Nested-aggregation-not-allowed/m-p/1266764#M398995 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview user</P><P></P><P>There are many answers out there and I have tried quite a few times, but cannot seem to return a value for the latest month. My aim is for the expression to always show the latest month and not interact with any other date selections</P><P></P><P>I created a variable as follows:</P><P></P><P><STRONG>Variable</STRONG></P><P>e_RTT_Max_Date = Max({1}If(data_source='RTT',FactDate))</P><P></P><P>This returns the value required</P><P></P><P>I then try and use this variable in an expression, but the result states that <SPAN style="text-decoration: underline;">nested aggregation is not allowed</SPAN></P><P></P><P><STRONG>Expression</STRONG></P><P>=Sum(If((Max(FactDate=$(e_RTT_Max_Date),RTT_BREACH_FLAG))</P><P></P><P>Could someone kindly point me in the right direction in how to obtain a value for latest month</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Thu, 23 Mar 2017 10:05:15 GMT helen_pip 2017-03-23T10:05:15Z Latest Month: Set Analysis (Issue# Nested aggregation not allowed) https://community.qlik.com/t5/QlikView/Latest-Month-Set-Analysis-Issue-Nested-aggregation-not-allowed/m-p/1266764#M398995 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview user</P><P></P><P>There are many answers out there and I have tried quite a few times, but cannot seem to return a value for the latest month. My aim is for the expression to always show the latest month and not interact with any other date selections</P><P></P><P>I created a variable as follows:</P><P></P><P><STRONG>Variable</STRONG></P><P>e_RTT_Max_Date = Max({1}If(data_source='RTT',FactDate))</P><P></P><P>This returns the value required</P><P></P><P>I then try and use this variable in an expression, but the result states that <SPAN style="text-decoration: underline;">nested aggregation is not allowed</SPAN></P><P></P><P><STRONG>Expression</STRONG></P><P>=Sum(If((Max(FactDate=$(e_RTT_Max_Date),RTT_BREACH_FLAG))</P><P></P><P>Could someone kindly point me in the right direction in how to obtain a value for latest month</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Thu, 23 Mar 2017 10:05:15 GMT https://community.qlik.com/t5/QlikView/Latest-Month-Set-Analysis-Issue-Nested-aggregation-not-allowed/m-p/1266764#M398995 helen_pip 2017-03-23T10:05:15Z