topic Sum in Straight Table Double Counting Some Rows in QlikView Layout & Visualizations
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444055#M24580
<HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML>Tue, 22 Jan 2013 15:06:21 GMTkmcgovern12013-01-22T15:06:21ZSum in Straight Table Double Counting Some Rows
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444055#M24580
<HTML><HEAD></HEAD><BODY><P>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!</P></BODY></HTML>Tue, 22 Jan 2013 15:06:21 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444055#M24580kmcgovern12013-01-22T15:06:21ZRe: Sum in Straight Table Double Counting Some Rows
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444056#M24581
<HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>I'm sending you the solution.</P><P>Aggregated by the correct field.</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>bye.</P></BODY></HTML>Tue, 22 Jan 2013 16:23:43 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444056#M24581christian772013-01-22T16:23:43ZRe: Sum in Straight Table Double Counting Some Rows
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444057#M24582
<HTML><HEAD></HEAD><BODY><P>Hi Christian, I think you forgot the attachment you referred to.</P></BODY></HTML>Tue, 22 Jan 2013 16:28:05 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444057#M24582kmcgovern12013-01-22T16:28:05ZRe: Sum in Straight Table Double Counting Some Rows
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444058#M24583
<HTML><HEAD></HEAD><BODY><P>Yes, it's to heavy and it took me out of the page.</P><P>Let me try that again...</P></BODY></HTML>Tue, 22 Jan 2013 16:29:25 GMThttps://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-in-Straight-Table-Double-Counting-Some-Rows/m-p/444058#M24583christian772013-01-22T16:29:25Z