topic Re: Duplicates lines in total expression in QlikView https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238021#M393565 <HTML><HEAD></HEAD><BODY><P>Can you please post sample data with QVW file?</P></BODY></HTML> Wed, 08 Feb 2017 17:27:50 GMT jayanttibhe 2017-02-08T17:27:50Z Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238020#M393564 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have a table with some calculation (conditions with dates and so), and my total works fine.</P><P>But, when i want to do a "summarized" table with just total, it removes costs :</P><P><IMG alt="pb_qv_finance.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/152495_pb_qv_finance.png" style="height: 299px; width: 620px;" /></P><P></P><P>Here is my calculation :</P><P><IMG alt="pb_qv_finance-2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/152496_pb_qv_finance-2.png" style="height: 193px; width: 620px;" /></P><P></P><P>I tried to change "Montant commande" by Sum(Montant commande), but it duplicates me costs&nbsp; :</P><P><IMG alt="pb_qv_finance-3.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/152498_pb_qv_finance-3.png" style="height: 243px; width: 620px;" /></P><P></P><P>I checked, normally i have juste one "montant commande" by N° BT, i don't understand why it's duplicating lines ...</P><P></P><P></P><P><SPAN style="font-size: 13.3333px;">Any idea ?</SPAN></P></BODY></HTML> Wed, 08 Feb 2017 17:06:59 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238020#M393564 oboute 2017-02-08T17:06:59Z Re: Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238021#M393565 <HTML><HEAD></HEAD><BODY><P>Can you please post sample data with QVW file?</P></BODY></HTML> Wed, 08 Feb 2017 17:27:50 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238021#M393565 jayanttibhe 2017-02-08T17:27:50Z Re: Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238022#M393566 <HTML><HEAD></HEAD><BODY><P>When you talking about Duplicates it should show same value for two times. on my <STRONG>visualization</STRONG> i didn't see any duplicates over there. Can you share the excel and please post the expression on wall</P></BODY></HTML> Thu, 09 Feb 2017 02:45:20 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238022#M393566 Anil_Babu_Samineni 2017-02-09T02:45:20Z Re: Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238023#M393567 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Here is a sample.</P><P>I know i could use a Sum(Distinct "Montant Commande") but i don't want to do that because it won't work with other calculation after, i would fix the problem at beginning by not duplicating those amounts</P></BODY></HTML> Thu, 09 Feb 2017 10:32:38 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238023#M393567 oboute 2017-02-09T10:32:38Z Re: Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238024#M393568 <HTML><HEAD></HEAD><BODY><P>I posted my qvw file</P></BODY></HTML> Fri, 10 Feb 2017 13:23:28 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238024#M393568 oboute 2017-02-10T13:23:28Z Re: Duplicates lines in total expression https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238025#M393569 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">I posted my qvw file</SPAN></P></BODY></HTML> Fri, 10 Feb 2017 13:23:35 GMT https://community.qlik.com/t5/QlikView/Duplicates-lines-in-total-expression/m-p/1238025#M393569 oboute 2017-02-10T13:23:35Z