Expression to ignore certain fields

helen_pip — Tue, 25 Apr 2017 19:52:04 GMT

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

Re: Expression to ignore certain fields

sunny_talwar — Wed, 26 Apr 2017 12:29:31 GMT

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

topic Expression to ignore certain fields in QlikView

Expression to ignore certain fields

Re: Expression to ignore certain fields