topic Re: Table Joining and summing in QlikView https://community.qlik.com/t5/QlikView/Table-Joining-and-summing/m-p/398277#M1161072 <HTML><HEAD></HEAD><BODY><P>Don't join them together. Keep them as two separate tables, and QlikView will sum correctly. Just make sure that you have a proper key between the tables.</P><P></P><P>HIC</P></BODY></HTML> Sat, 03 Nov 2012 11:20:26 GMT hic 2012-11-03T11:20:26Z Table Joining and summing https://community.qlik.com/t5/QlikView/Table-Joining-and-summing/m-p/398276#M1161071 <HTML><HEAD></HEAD><BODY><P>I have two tables that I am joining together where there is a one to many relationship.&nbsp; Now I am trying to do a sum on a field from the first table (one) but my number is way to large which I think is due to the second table having the many to one relationship.</P></BODY></HTML> Fri, 02 Nov 2012 21:09:17 GMT https://community.qlik.com/t5/QlikView/Table-Joining-and-summing/m-p/398276#M1161071 2012-11-02T21:09:17Z Re: Table Joining and summing https://community.qlik.com/t5/QlikView/Table-Joining-and-summing/m-p/398277#M1161072 <HTML><HEAD></HEAD><BODY><P>Don't join them together. Keep them as two separate tables, and QlikView will sum correctly. Just make sure that you have a proper key between the tables.</P><P></P><P>HIC</P></BODY></HTML> Sat, 03 Nov 2012 11:20:26 GMT https://community.qlik.com/t5/QlikView/Table-Joining-and-summing/m-p/398277#M1161072 hic 2012-11-03T11:20:26Z