topic Re: Cases when we get more data using joins. in QlikView

Cases when we get more data using joins.

retko1985 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Cases when we get more data using joins.

Mark_Little — Fri, 01 Dec 2017 10:23:02 GMT

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

Re: Cases when we get more data using joins.

prma7799 — Fri, 01 Dec 2017 10:28:34 GMT

Please check this

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