Discussion board where members can get started with QlikView.
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.
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.
View solution in original post
Please check this