topic Duplicate Computations in Total Value in QlikView https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480065#M1130792 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hello!&nbsp; Pls. help me solve my problem...I've been stuck with this issue for days...&nbsp; I have a chart table that some values in my total value&nbsp; (under Expressions tab) got duplicated while some were ok... My formula is just simple</SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp; ({&lt;<SPAN style="color: #800000;">Source</SPAN>={'Category}&gt;}<SPAN style="color: #800000;">TotalValue</SPAN>) ....If i put the total value field in the dimensions, computaions seems ok ... But it doesn't allow me to take out the expressions 'coz it will give me 0 records..&nbsp; Not sure if it has something to do with the synthetic table which I have trouble i fixing it...&nbsp; I also tried switching to pivot table to no avail.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Pls. help.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Tks.</SPAN></P><P> </P><P> </P><P> </P><P> </P><P></P><P><BR /> </P></BODY></HTML> Fri, 22 Nov 2013 18:46:34 GMT Anonymous 2013-11-22T18:46:34Z Duplicate Computations in Total Value https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480065#M1130792 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hello!&nbsp; Pls. help me solve my problem...I've been stuck with this issue for days...&nbsp; I have a chart table that some values in my total value&nbsp; (under Expressions tab) got duplicated while some were ok... My formula is just simple</SPAN></P><P><SPAN style="font-size: 10pt;">&nbsp; ({&lt;<SPAN style="color: #800000;">Source</SPAN>={'Category}&gt;}<SPAN style="color: #800000;">TotalValue</SPAN>) ....If i put the total value field in the dimensions, computaions seems ok ... But it doesn't allow me to take out the expressions 'coz it will give me 0 records..&nbsp; Not sure if it has something to do with the synthetic table which I have trouble i fixing it...&nbsp; I also tried switching to pivot table to no avail.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Pls. help.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Tks.</SPAN></P><P> </P><P> </P><P> </P><P> </P><P></P><P><BR /> </P></BODY></HTML> Fri, 22 Nov 2013 18:46:34 GMT https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480065#M1130792 Anonymous 2013-11-22T18:46:34Z Re: Duplicate Computations in Total Value https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480066#M1130793 <HTML><HEAD></HEAD><BODY><P>try this</P><P><SPAN style="font-size: 10pt;">sum( distinct {&lt;<SPAN style="color: #800000;">Source</SPAN>={'Category}&gt;}<SPAN style="color: #800000;">TotalValue</SPAN>)</SPAN></P></BODY></HTML> Fri, 22 Nov 2013 19:07:18 GMT https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480066#M1130793 2013-11-22T19:07:18Z Re: Duplicate Computations in Total Value https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480067#M1130794 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">you´re missing a quote after "category", did you noticed it?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({&lt;</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Source</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">={'Category}&gt;}</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">TotalValue</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)</SPAN></P></BODY></HTML> Fri, 22 Nov 2013 19:28:51 GMT https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480067#M1130794 Clever_Anjos 2013-11-22T19:28:51Z Re: Duplicate  Computations in Total Value https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480068#M1130795 <HTML><HEAD></HEAD><BODY><P><BR />Thank you,&nbsp; Vishwaranjan...this one works.</P></BODY></HTML> Tue, 03 Dec 2013 01:13:39 GMT https://community.qlik.com/t5/QlikView/Duplicate-Computations-in-Total-Value/m-p/480068#M1130795 Anonymous 2013-12-03T01:13:39Z