topic Re: sum is doubling? using straight table- only one table accessed in QlikView https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394106#M1156069 <HTML><HEAD></HEAD><BODY><P>shoot-&nbsp; forgot about that-&nbsp;&nbsp; checking now.</P></BODY></HTML> Tue, 26 Mar 2013 16:29:58 GMT ellyodelly 2013-03-26T16:29:58Z sum is doubling? using straight table- only one table accessed https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394104#M1156067 <HTML><HEAD></HEAD><BODY><P>I have a chart but the total on the chart didnt match the total in my straight table which had no totaling.</P><P>just figured i had a dimension wrong-&nbsp; so I added my sum column to my straight table- see attached.</P><P>the two expressions are inv amt-&nbsp; which is just the invoiced amt&nbsp; no totaling just a copy of the existing field</P><P>the tot inv is the sum using a set analysis... which is shown.</P><P>If all the rows were doubling I could maybe understand more-&nbsp; but one is right and the other double.</P><P></P><P>what am i confusing now?</P></BODY></HTML> Tue, 26 Mar 2013 15:37:44 GMT https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394104#M1156067 ellyodelly 2013-03-26T15:37:44Z Re: sum is doubling? using straight table- only one table accessed https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394105#M1156068 <HTML><HEAD></HEAD><BODY><P>Could like you have duplicate records? QlikView would display duplicate records just once in the straight table.</P></BODY></HTML> Tue, 26 Mar 2013 16:07:35 GMT https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394105#M1156068 m_woolf 2013-03-26T16:07:35Z Re: sum is doubling? using straight table- only one table accessed https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394106#M1156069 <HTML><HEAD></HEAD><BODY><P>shoot-&nbsp; forgot about that-&nbsp;&nbsp; checking now.</P></BODY></HTML> Tue, 26 Mar 2013 16:29:58 GMT https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394106#M1156069 ellyodelly 2013-03-26T16:29:58Z Re: sum is doubling? using straight table- only one table accessed https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394107#M1156070 <HTML><HEAD></HEAD><BODY><P>it was a join-&nbsp; now to fix it-&nbsp; hmmm&nbsp; thanks for direction.</P></BODY></HTML> Tue, 26 Mar 2013 18:08:42 GMT https://community.qlik.com/t5/QlikView/sum-is-doubling-using-straight-table-only-one-table-accessed/m-p/394107#M1156070 ellyodelly 2013-03-26T18:08:42Z