Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Joining and summing

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.

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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.

HIC

View solution in original post

1 Reply
hic
Former Employee
Former Employee

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.

HIC