Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Henric_Cronström
Not applicable

Re: Table Joining and summing

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

1 Reply
Henric_Cronström
Not applicable

Re: Table Joining and summing

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