Expression to ignore certain fields

[helen_pip]

Dear Qlikvew user

I have written an expression which shows me a % for the most recent month.  I thought my code was robust enough to ignore user selections on FiscalYear, Month and Quarter, as I want the expression to remain static when user makes a selection from the date selection

I know I can use alternate states, but thought this code would ignore the necessary fields?  Would alternate states be a better way of ignoring the date fields?

Num((sum({<Month,QuarterName,FiscalYear,FactDate = {">=$(=MonthStart(max(FactDate))) <=$(=MonthEnd(max(FactDate)))"}>}RTT_COUNTER)-

sum({<Month,QuarterName,FiscalYear,FactDate = {">=$(=MonthStart(max(FactDate))) <=$(=MonthEnd(max(FactDate)))"}>}RTT_BREACH_FLAG))

Kind Regards

Helen

[sunny_talwar]

May be this

Num((Sum({<Month, QuarterName, FiscalYear, FactDate = {">=$(=MonthStart(Max({<Month, QuarterName, FiscalYear, FactDate>} FactDate))) <=$(=MonthEnd(Max({<Month, QuarterName, FiscalYear, FactDate>} FactDate)))"}>}RTT_COUNTER)-

sum({<Month,QuarterName,FiscalYear,FactDate = {">=$(=MonthStart(Max({<Month, QuarterName, FiscalYear, FactDate>} FactDate))) <=$(=MonthEnd(Max({<Month, QuarterName, FiscalYear, FactDate>} FactDate)))"}>} RTT_BREACH_FLAG))