why sum(sales) is effecting..

[purna]

Hello qlikers,

Hear i have the data like  attached below while i am trying to join (left , right) the sum of sales are also changing,

Is this the issue is regarding the primary key & foreign key.

If its so how can i change the data according to the front end that it should not effect the sales or anything.

what are the fields to be modified.

Thanks in advance.....,

Regards...

Note: This data is taken manually.

[Vegar]

It looks like you don't have any common field names in the two tables, this means that you ste not joining on ant field. The result will be the cartesian product  of the two. Your sum of sales will be duplicated by the number of lines in your second table.

Try to identify on which  fields you want the tables to join and make sure these two field names are identical.