topic ignore duplicate records in QlikView

ignore duplicate records

Anonymous — Thu, 08 Mar 2018 11:09:10 GMT

Hello,

I have a table, that looks like this:

Now I wanna make a sum() over all the costs but with every "total cost" of every "number" only once.

So the sum() should be 1.100 and not 2.600?? Is there a function for this?

Thank you in advance

Tina

tresB — Thu, 08 Mar 2018 11:19:47 GMT

Straight table:

Dim: Number

Exp: Sum( Distinct [total costs])

In text box: =Sum(Aggr(Sum( Distinct [total costs]), Number))

Edit: corrected bracket

big_dreams — Thu, 08 Mar 2018 12:44:22 GMT

why don't you load distinct records during load statement?

like Load distinct Number, cost from table

Regards,