topic Re: Duplicate Values from Join in QlikView

Duplicate Values from Join

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have this two tables that I joined but the values are duplicated. How can I divide the value 8.26 for every IMEI that occurs in the example?

Thank you.

adamdavi3s — Mon, 20 Feb 2017 12:16:21 GMT

I don't think they are duplicated, the data looks good to me.

In your test table you might just want to exclude where len(IMEI) <1

e.g. if(len(IMEI)<1,0,IMEI/Value)

Mon, 20 Feb 2017 12:52:22 GMT

Hello Adam,

Thank you for your answer but the values are duplicated. For every IMEI the value should be 4.13(for this example).

antoniotiman — Mon, 20 Feb 2017 16:32:06 GMT

Hi Doru,

try

Sum(Value)/Count(DISTINCT TOTAL <Product> IMEI)

Regards,

Antonio

Tue, 21 Feb 2017 12:19:01 GMT

Thank you Antonio