How to close of a set analysis expression

[helen_pip]

Dear Qlikview User,

I was wondering if someone could kidnly cast an eye over the following expression, as I am unsure where I should be closing off the set analysis and I am getting the following error message:

Error is set modifier expression

=Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth),If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)RTT_COUNTER), '0.00%')

Kind Regards

Helen

[tresesco · Accepted solution]

May be this:

=Num(sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>} If(RTT_WEEKS_WAIT <'18', RTT_COUNTER))/

sum({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevMonth)>}RTT_COUNTER), '0.00%')

Note: comma removed before If .. and other correction highlighted in bold

[helen_pip]

Thank you! This works