topic Re: How do I Sum a Value for Another Distict Value? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323616#M836655 <HTML><HEAD></HEAD><BODY><P>Thank you SO much!!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 May 2017 20:38:38 GMT 2017-05-23T20:38:38Z How do I Sum a Value for Another Distict Value? https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323614#M836653 <HTML><HEAD></HEAD><BODY><P>How do I sum the total leg empty miles for distinct leg values? The answer should be 292 for this dataset. I tried this but it is only counting.</P><P></P><P></P><P>sum(aggr(count(distinct([TMW leg#])),TotalLegEmptyMiles))<BR /> </P><P></P><TABLE border="0" cellpadding="2" cellspacing="0" width="208"><TBODY><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">TMW leg#</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">TotalLegEmptyMiles</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">263226</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">0</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260442</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">93</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260442</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">93</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260442</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">93</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260377</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">0</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260294</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">0</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260293</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">25</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260278</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">0</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260264</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">20</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260263</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">73</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260262</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">31</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260261</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">25</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260260</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">17</SPAN></P></TD></TR><TR><TD height="19" width="32%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">260257</SPAN></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">8</SPAN></P></TD></TR><TR><TD height="19" width="32%"><P></P></TD><TD height="19" width="68%"><P></P></TD></TR><TR><TD height="19" width="32%"><P></P></TD><TD height="19" width="68%"> <P><SPAN style="font-size: 12pt; font-family: Calibri;">292</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323614#M836653 2020-11-25T16:16:04Z Re: How do I Sum a Value for Another Distict Value? https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323615#M836654 <HTML><HEAD></HEAD><BODY><P>Are you looking for</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(aggr( Only(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TotalLegEmptyMiles),</SPAN> [TMW leg#] ))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">? </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Tue, 23 May 2017 20:30:22 GMT https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323615#M836654 swuehl 2017-05-23T20:30:22Z Re: How do I Sum a Value for Another Distict Value? https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323616#M836655 <HTML><HEAD></HEAD><BODY><P>Thank you SO much!!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 23 May 2017 20:38:38 GMT https://community.qlik.com/t5/QlikView/How-do-I-Sum-a-Value-for-Another-Distict-Value/m-p/1323616#M836655 2017-05-23T20:38:38Z