topic Joining tables in QlikView https://community.qlik.com/t5/QlikView/Joining-tables/m-p/218188#M71353 <HTML><HEAD></HEAD><BODY><P>Hi Rishi,</P><P>Can u please attach the file .....</P></BODY></HTML> Thu, 21 Jan 2010 06:35:58 GMT spsrk_84 2010-01-21T06:35:58Z Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/218187#M71352 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am new in Qlikview and am having a problem joining 12 tables together which are cumulative tables consisting of 12 monthly loads of data.</P><P>The structure of the tables are the same except for the contents which means that the tables are growing each month.</P><P>For example January has got 500 records with recordings in 25 sales units,<BR />February has got 550 records with recordings over 27 units etc. I would like to perform a right join over the 12 tables. So all the 550 records of February will be joined with the 500 records of January and so on. What I have encountered is that after the second join the results are unexpected.</P><P>How many tables can be joined in one query and any ideas on how to solve the problem as described above?</P><P>Thanks in advance!</P><P>Rishi.</P></BODY></HTML> Wed, 20 Jan 2010 21:28:00 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/218187#M71352 2010-01-20T21:28:00Z Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/218188#M71353 <HTML><HEAD></HEAD><BODY><P>Hi Rishi,</P><P>Can u please attach the file .....</P></BODY></HTML> Thu, 21 Jan 2010 06:35:58 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/218188#M71353 spsrk_84 2010-01-21T06:35:58Z