Data loader - using autocalendar.Year

[josemariagarcia]

This is probably a very basic question (I am a newbie with Qlik). I'd like to create a new table based on an existing one. I want that table to contain a field from autocalendar. I am trying the following code:

[Stats]:
NOCONCATENATE
Load
  [Expected date.autoCalendar.Year] as Year,
  Count([Dossier Ref]) as Dossiers
Resident [Sheet1] WHERE MATCH([Type], 'A', 'B', 'C')
GROUP BY [Year];

It is complaining about "Field 'Year' not found"

What am I doing wrong?

[rwunderlich]

"Year" doesn't exist until after the load is completed. Perhaps instead:

GROUP By [Expected date.autoCalendar.Year]

-Rob

[josemariagarcia]

That did not worked: 

Field 'Expected date.autoCalendar.Year' not found

But I managed to make it work with:

GROUP BY Year([Expected date])