topic Why is my dates not joining correctly in QlikView

Why is my dates not joining correctly

Anonymous — Mon, 29 Jun 2015 07:01:19 GMT

Hi everyone.

So I have 2 tables, one called DATES and one called FCT. Now, in picture 1, you can see that both tables have a column called day date that are joined in the back-end. now, when I select a Date on the FCT table, the values on the DATES table goes blank, as in picture 2.

Does anyone know why this could be? Help will be appreciated thanks

Re: Why is my dates not joining correctly

pokassov — Mon, 29 Jun 2015 07:04:42 GMT

Hello!

Can you attach you qlik document?

It looks like you don't have lines for Day Date for 20120811 in first table.

Re: Why is my dates not joining correctly

avinashelite — Mon, 29 Jun 2015 07:25:07 GMT

Hi Stefan,

It look's like data issue or formatting issue, can you please share your app ??

it will be helpful debug

Re: Why is my dates not joining correctly

jagan — Mon, 29 Jun 2015 07:30:56 GMT

Hi,

While loading convert the date field to Date using Date() in both the tables, then this will work. I think currently the dates are loading as numbers, this is a formatting issue.

Table1:

LOAD

Date(Date#([Day Data No], 'YYYYMMDD')) AS Date,

FROM DataSource1;

Table2:

LOAD

Date(Date#([Day Data No], 'YYYYMMDD')) AS Date,

FROM DataSource2;

Hope this helps you.

Regards,

jagan.

Re: Why is my dates not joining correctly

Anonymous — Mon, 29 Jun 2015 07:35:15 GMT

Hi Jagan, and thanks for the solution. This worked perfectly

Re: Why is my dates not joining correctly

Anonymous — Mon, 29 Jun 2015 07:36:09 GMT

Hi there, unfortunately Im not allowed to share the app as its an internal company app of ours. I got the answer to my problem. thanks for the help anyway

Re: Why is my dates not joining correctly

Anonymous — Mon, 29 Jun 2015 07:36:23 GMT

Hi there, unfortunately Im not allowed to share the app as its an internal company app of ours. I got the answer to my problem. thanks for the help anyway