Why is my dates not joining correctly

[Anonymous]

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

[pokassov]

Hello!

Can you attach you qlik document?

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

[avinashelite]

Hi Stefan,

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

it will be helpful debug

[jagan · Accepted solution]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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