I have two tables that I am joining together where there is a one to many relationship. 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.
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.
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.
.png "Former Employee"){kind=icon}