topic Re: sum(value) doubles values in QlikView

sum(value) doubles values

Wed, 23 Mar 2016 08:12:18 GMT

Good Morning,

I have a Problem with my Pivot.

I have a table with all docnum related to an asset. Some docnums have more than one line (doclinenum).

he calculation "sum(valuehome)" calculated wrong. It takes in every line the amount of both lines and sums up the wrong way (1.439,30 instaed of 719,65)..

I thought of just taking valuehome instaed of sum(valuehome), but then I dont get totals.

In the pic below the total of "sum(valuehome)" is wrong and only "valuehome" does not Show a Total.

How can I solve this Problem? I want to have the correct amount in every line (719,65) and the correct sum (1.439,30).

Thanks in advance.

Chris

Re: sum(value) doubles values

Gysbert_Wassenaar — Wed, 23 Mar 2016 08:45:45 GMT

Divide the sum by the count of doclinenum values: sum(valuehome)/count(total <docnum> doclinenum)

Re: sum(value) doubles values

Kushal_Chawda — Wed, 23 Mar 2016 08:51:13 GMT

try

sum(distinct valuehome)

Re: sum(value) doubles values

jjbom1990 — Wed, 23 Mar 2016 08:56:35 GMT

I would say that you need to add a distinct to the dimension 'doclinenum' =count(distinct(doclinenum))

that way you filter out the double numbers. and the count should work properly.

(I am not entirely sure, I am not able to test it right now.)

Re: sum(value) doubles values

jagan — Wed, 23 Mar 2016 09:13:32 GMT

Hi,

Try like this

Sum(Agg(Sum(MeasureName), docnum))

Regards,

Jagan.

Re: sum(value) doubles values

kkkumar82 — Wed, 23 Mar 2016 10:26:13 GMT

Hi, try Max rather than sum if the values are same. Thanks Kiran Kumar