Thanks for your input. I have seen that numeric comparison works with and without single quotes while string comparison demands single quotes. Therefore, I usually follow the common one. If you have come across any scenario when single quotes don't work, please let me know, it would enrich my experience.
What you can do is:
2) Define a variable :vWeek=max(Week)
Load Week resident ABC whereWeek<=$(vWeek);
From XYZ.QVD ;
' Week ' is present in table ABC and not XYZ,so it s not going to find that field anyway.
Try the above,hope this works.
please let me know its result.