Cases when we get more data using joins.

[retko1985]

Hello,

I heard that in some situations, using wrongly join will generate more data, and I will probably get bigger number when I do SUM. Can someone think of some examples? And also probably how to do it correctly.

Thank you.

[Mark_Little · Accepted solution]

Hi,

One example would be With Orders. Say you have order header and you have have order lines.

The header hold the total and the line the individual line values.

If you load the lines and then left Join head, the total will show on each line.

So if you SUM(TotalOrderValue) this value will bigger as it will be multiplied by the number of lines on the order.

It maybe fine to do the above, but you would have to make sure you're aware of the Aggreation front end.

Mark

[prma7799]

Please check this

https://www.resultdata.com/using-joins-in-qlikview/