Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis.. I oversee something, but what?

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

2 Replies
Not applicable
Author

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

Not applicable
Author

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