topic Re: Month in cross table does not match date field in QlikView

Month in cross table does not match date field

qlikhans — Wed, 25 Feb 2015 07:50:14 GMT

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

Re: Month in cross table does not match date field

Wed, 25 Feb 2015 08:05:11 GMT

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

robert_mika — Wed, 25 Feb 2015 08:25:29 GMT

Try:

Directory;

LOAD YEAR(Date) as Year,

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

Re: Month in cross table does not match date field

qlikhans — Wed, 25 Feb 2015 09:57:23 GMT

Hi Robert,

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

beste rgrds

Hans