topic Re: calculated field sum in App Development https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427005#M34107 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en">I want to sum up</SPAN></P><P><SPAN class="short_text" lang="en"><IMG alt="table.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176788_table.png" style="height: auto;" /></SPAN></P></BODY></HTML> Fri, 15 Sep 2017 14:01:18 GMT davidoxi 2017-09-15T14:01:18Z calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427003#M34105 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">I want to sum the general total of calculation field</SPAN> :</P><P><IMG alt="table.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176787_table.png" style="height: auto;" /> </P></BODY></HTML> Fri, 15 Sep 2017 13:40:02 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427003#M34105 davidoxi 2017-09-15T13:40:02Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427004#M34106 <HTML><HEAD></HEAD><BODY><P>This seems like a straight table, try to set total mode to sum on the expression tab for NB Commande_Stock expression</P></BODY></HTML> Fri, 15 Sep 2017 13:43:39 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427004#M34106 sunny_talwar 2017-09-15T13:43:39Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427005#M34107 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en">I want to sum up</SPAN></P><P><SPAN class="short_text" lang="en"><IMG alt="table.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176788_table.png" style="height: auto;" /></SPAN></P></BODY></HTML> Fri, 15 Sep 2017 14:01:18 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427005#M34107 davidoxi 2017-09-15T14:01:18Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427006#M34108 <HTML><HEAD></HEAD><BODY><P>What are the expressions you are using? Would you be able to share a sample?</P></BODY></HTML> Fri, 15 Sep 2017 14:02:27 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427006#M34108 sunny_talwar 2017-09-15T14:02:27Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427007#M34109 <HTML><HEAD></HEAD><BODY><P>Somme_LN_UrgentT /(Somme LN_Stock +Somme_LN_URGAENT )</P></BODY></HTML> Fri, 15 Sep 2017 14:12:11 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427007#M34109 davidoxi 2017-09-15T14:12:11Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427008#M34110 <HTML><HEAD></HEAD><BODY><P>Other two expressions?</P></BODY></HTML> Fri, 15 Sep 2017 14:25:10 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427008#M34110 sunny_talwar 2017-09-15T14:25:10Z Re: calculated field sum https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427009#M34111 <HTML><HEAD></HEAD><BODY><P></P><P>Somme LN_Urgent&nbsp; = <SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Type de commande]</SPAN><SPAN style="font-size: 8pt;">, 'URGENT','GROS', 'PVI')&gt;0, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN>;</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Somme LN_Stock = sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">match</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Type de commande]</SPAN><SPAN style="font-size: 8pt;">,'STOCK','PROMO')&gt;0, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° ligne]</SPAN><SPAN style="font-size: 8pt;">)),</SPAN><SPAN style="color: #800000; font-size: 8pt;">[N° donneur d'ordre]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P></BODY></HTML> Fri, 15 Sep 2017 14:27:29 GMT https://community.qlik.com/t5/App-Development/calculated-field-sum/m-p/1427009#M34111 davidoxi 2017-09-15T14:27:29Z