Month in cross table does not match date field

[qlikhans]

I am having an issue in matching periods/months that head a crosstable to dates in a text file. Attached are examples of my data files, the output [actual generated versus what I need] and the QV document.

I have tried to change the headings to actual month names, did not work.

I go for easy solutions. So if the headings of the crosstable need to be changed, that can be done.

Who can help me?

thanks

Hans

[#2]

if you do not mind, could you elaborate issue in way that no need to look into attachments?

[robert_mika · Accepted solution]

Try:

Directory;

LOAD YEAR(Date) as Year,

  Text(Date(Date,'MM')) as Period,

[qlikhans]

Hi Robert,

That just did the trick. Thank you for your help.

beste rgrds

Hans