Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

qlikhans
Contributor

Month in cross table does not match date field

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

Tags (1)
1 Solution

Accepted Solutions

Re: Month in cross table does not match date field

Try:

Directory;

LOAD YEAR(Date) as Year,

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

3 Replies
Not applicable

Re: Month in cross table does not match date field

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

Re: Month in cross table does not match date field

Try:

Directory;

LOAD YEAR(Date) as Year,

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

qlikhans
Contributor

Re: Month in cross table does not match date field

Hi Robert,

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

beste rgrds

Hans