topic Sum in Straight Table Double Counting Some Rows in QlikView

Sum in Straight Table Double Counting Some Rows

Anonymous — Tue, 22 Jan 2013 15:06:21 GMT

So I'm trying to do a sum of a dollar amount in a straight table but some rows are being counted twice. If you look at the attached example, the row where the PARHrs are 1.3898 shows an amount of $112.20 in the table box but when I do Sum(PARAmt) in the straight table, a value of $224.40 is displayed. This issue appears in a couple different places. When I do a Sum(Distinct PARAmt) the true amount is displayed but I'm worried about this showing a smaller amount than expected under different scenarios. Any insight into why the straight table would be doubling some of the values here would be greatly appreciated! Thank you!

Re: Sum in Straight Table Double Counting Some Rows

christian77 — Tue, 22 Jan 2013 16:23:43 GMT

Hi:

I'm sending you the solution.

Aggregated by the correct field.

Don't use sum(distinct Field), since values can be the same. Distinct is used for count, at least there is a special calculation you need to do, but normally that's wrong.

In the example, see the totalizers are different but the total is the same. That means the sum and the total expression are matching, therefore, it is right.

bye.

Re: Sum in Straight Table Double Counting Some Rows

Anonymous — Tue, 22 Jan 2013 16:28:05 GMT

Hi Christian, I think you forgot the attachment you referred to.

Re: Sum in Straight Table Double Counting Some Rows

christian77 — Tue, 22 Jan 2013 16:29:25 GMT

Yes, it's to heavy and it took me out of the page.

Let me try that again...