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