Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
"Year" doesn't exist until after the load is completed. Perhaps instead:
GROUP By [Expected date.autoCalendar.Year]
-Rob
That did not worked:
Field 'Expected date.autoCalendar.Year' not found
But I managed to make it work with:
GROUP BY Year([Expected date])