topic Trouble with triple data! in QlikView https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209373#M64391 <HTML><HEAD></HEAD><BODY><P>I understand but posting the structure is difficult <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 20 Sep 2010 13:03:45 GMT timmy 2010-09-20T13:03:45Z Trouble with triple data! https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209371#M64389 <HTML><HEAD></HEAD><BODY><P>Hellow,</P><P>can somebody help me with this problem?</P><P>invoice effective_date name product description long_description quantity val =sum(quantity)<BR />OP/I217596 29/01/2010 00:00:00 BASF AGRI-PRODUCTION RP0072 - - 60 0 180<BR />OP/I217596 29/01/2010 00:00:00 BASF AGRI-PRODUCTION 5L C95 HDPE 220G M GRIFAP JAUNE P072 10080 56 30240</P><P>This data comes out of the pivot table box that i have created.</P><P>You can see that the formula triples my actual data...</P><P>How can i solve this and why does this happen?</P></BODY></HTML> Mon, 20 Sep 2010 12:44:45 GMT https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209371#M64389 timmy 2010-09-20T12:44:45Z Trouble with triple data! https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209372#M64390 <HTML><HEAD></HEAD><BODY><P>Hi Timmy,</P><P>Without know your data structure, help you, will be a little complicated.</P><P>Regards.</P><P></P></BODY></HTML> Mon, 20 Sep 2010 12:53:42 GMT https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209372#M64390 2010-09-20T12:53:42Z Trouble with triple data! https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209373#M64391 <HTML><HEAD></HEAD><BODY><P>I understand but posting the structure is difficult <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 20 Sep 2010 13:03:45 GMT https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209373#M64391 timmy 2010-09-20T13:03:45Z Trouble with triple data! https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209374#M64392 <HTML><HEAD></HEAD><BODY><P>the formula wont be tripling the data, something else will be. if you did coun(quantity) instead of sum you'll probably get 3.<BR /><BR />can you attach the file and i can help you look for the duplicate.</P><P></P><P>Thanks</P><P></P><P>Rick</P><P></P></BODY></HTML> Mon, 20 Sep 2010 14:36:10 GMT https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209374#M64392 2010-09-20T14:36:10Z Trouble with triple data! https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209375#M64393 <HTML><HEAD></HEAD><BODY><P>Could you post a sample of your data?</P></BODY></HTML> Mon, 20 Sep 2010 14:41:16 GMT https://community.qlik.com/t5/QlikView/Trouble-with-triple-data/m-p/209375#M64393 Clever_Anjos 2010-09-20T14:41:16Z