Problem with joins

[jvitantonio]

Hi all, I need some help.

I need to join 3 tables. Right now I'm joining the tables automatically as Qlik does it but it doesn't seem to be working. This is my structure:

Table1:

Key_A

DATE

Table2:

Key_A

Key_B

Table3:

Key_B

Now, I need to be able to filter data from Table3 with the DATE field in TAble1. I don't know why, but when I use the DATE field, it all goes to only one year (I have data for 2009, 2010), but I make a count and it says 2009 = 0 and 2010 = all records.

How should I be doing this join? Is there anything I'm not doing right?

Thanks

[#2]

Hi,

Can you please post your script and sample data.

Cheers.

[jvitantonio · Accepted solution]

I think I'm done. I use left joins instead of letting qlik doing the joins for me