topic Set analysis.. I oversee something, but what? in QlikView

Set analysis.. I oversee something, but what?

Wed, 20 Jul 2011 12:04:16 GMT

I'm using this set analysis formula, however it's ginving no result.

If(sum(CountOf_Questionnaire_number)>=100,Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Bookyear=,Monthname=,Quarter=,Quater_name=>} Satisfaction_Score)/Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM'))},Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Yearmonth=,Bookyear=,Monthname=,Quarter=,Quater_name=>} pond),'Obs < 100')

However this part

=(Date(AddMonths(Max(Date#(Yearmonth, 'YYYY MM')), -3), 'YYYY MM'))

Show correctly 2011 01

I've looked at it for a while, but I can't seem to find out what's causing the problem here.

Best regards,

Arjan

Set analysis.. I oversee something, but what?

Wed, 20 Jul 2011 12:07:00 GMT

And alsi with the simplified formula it's not working..

If(sum(CountOf_Questionnaire_number)>=100,Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Bookyear=,Monthname=,Quarter=,Quater_name=>} Satisfaction_Score)/Sum({$<Yearmonth={$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-2),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-1),'YYYY MM')),$(=Date(AddMonths(Max(Date#(Yearmonth,'YYYY MM')),-0),'YYYY MM'))},Yearnumber=,Monthnumber=,Quarter_code=,Bookyear_code=,Yearmonth=,Bookyear=,Monthname=,Quarter=,Quater_name=>} pond),'Obs < 100')

Set analysis.. I oversee something, but what?

Wed, 20 Jul 2011 12:19:53 GMT

Finally found. For some reason set analysis has a problem with the space in the field YearMonth (YYYY MM).

Just used another value and that seems to work fine..