topic Excluding duplicates in a SUM in QlikView https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279319#M103953 <HTML><HEAD></HEAD><BODY><P>Seems to do the job very nicely thanks!!</P><P></P><P>Matt</P></BODY></HTML> Thu, 27 Oct 2011 15:22:59 GMT 2011-10-27T15:22:59Z Excluding duplicates in a SUM https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279317#M103951 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a dataset which returns projects and programmes from our project management system.</P><P></P><P>sometimes a project will be within 2 levels of programs</P><P>as a result if I select the top level in my QVW, it will sum up multiple instances of a project.</P><P></P><P>how can I tell it to SUM by&nbsp; distinct project code</P><P></P><P>my current expression is:</P><P>SUM(BUDGET_DAYS)</P><P></P><P>I need it by distinct PROJECT_CODE</P><P></P><P></P><P>Thanks in advance,</P><P>Matt</P></BODY></HTML> Thu, 27 Oct 2011 14:13:48 GMT https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279317#M103951 2011-10-27T14:13:48Z Excluding duplicates in a SUM https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279318#M103952 <HTML><HEAD></HEAD><BODY><P>This might work. Can you give it a try?</P><P>sum(aggr(SUM(Distinct BUDGET_DAYS), PROJECT_CODE))</P><P></P><P>Kiran.</P></BODY></HTML> Thu, 27 Oct 2011 15:08:00 GMT https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279318#M103952 2011-10-27T15:08:00Z Excluding duplicates in a SUM https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279319#M103953 <HTML><HEAD></HEAD><BODY><P>Seems to do the job very nicely thanks!!</P><P></P><P>Matt</P></BODY></HTML> Thu, 27 Oct 2011 15:22:59 GMT https://community.qlik.com/t5/QlikView/Excluding-duplicates-in-a-SUM/m-p/279319#M103953 2011-10-27T15:22:59Z