topic Re: Sum duplication - object level in QlikView

Sum duplication - object level

ranibosch — Thu, 25 Jan 2018 14:39:11 GMT

good day,

please find attached a file of my results on my model.

my problem is that if I sum my quantities on the object, my tonnage and units sold are over stated.

furthermore, should I fix this on a object or total script level?

thanks!

Re: Sum duplication - object level

sunny_talwar — Thu, 25 Jan 2018 15:01:32 GMT

It would be ideal to fix this in the script by may be creating a separate table which keeps ItemsSold.ItemNo, ItemSold.Document No and all the those number which have one to one relationship with those two fields. This way, when you sum them, you won't be duplicating them. But if change the script is not a possibility... you can try this

Sum(Aggr(Sum(DISTINCT [ItemsSold.No of Units Sold]), [ItemsSold.Item No], [ItemSold.Document No]))

Re: Sum duplication - object level

ranibosch — Thu, 25 Jan 2018 15:07:28 GMT

thanks, i've sorted this out in my script using temporary loads and then grouping it by document number..