Latest Month: Set Analysis (Issue# Nested aggregation not allowed)

[helen_pip]

Dear Qlikview user

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

I created a variable as follows:

Variable

e_RTT_Max_Date = Max({1}If(data_source='RTT',FactDate))

This returns the value required

I then try and use this variable in an expression, but the result states that nested aggregation is not allowed

Expression

=Sum(If((Max(FactDate=$(e_RTT_Max_Date),RTT_BREACH_FLAG))

Could someone kindly point me in the right direction in how to obtain a value for latest month

Kind Regards

Helen