topic Re: Problem with joins in QlikView https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255258#M96582 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you please post your script and sample data.</P><P></P><P>Cheers.</P></BODY></HTML> Tue, 18 Oct 2011 09:45:22 GMT 2011-10-18T09:45:22Z Problem with joins https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255257#M96581 <HTML><HEAD></HEAD><BODY><P>Hi all, I need some help.</P><P></P><P></P><P>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:</P><P></P><P>Table1:</P><P>Key_A</P><P>DATE</P><P></P><P>Table2:</P><P>Key_A</P><P>Key_B</P><P></P><P>Table3:</P><P>Key_B</P><P></P><P>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. </P><P></P><P>How should I be doing this join? Is there anything I'm not doing right?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 18 Oct 2011 07:14:37 GMT https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255257#M96581 jvitantonio 2011-10-18T07:14:37Z Re: Problem with joins https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255258#M96582 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you please post your script and sample data.</P><P></P><P>Cheers.</P></BODY></HTML> Tue, 18 Oct 2011 09:45:22 GMT https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255258#M96582 2011-10-18T09:45:22Z Problem with joins https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255259#M96583 <HTML><HEAD></HEAD><BODY><P>I think I'm done. I use left joins instead of letting qlik doing the joins for me</P></BODY></HTML> Tue, 18 Oct 2011 14:31:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-joins/m-p/255259#M96583 jvitantonio 2011-10-18T14:31:42Z