topic Re: Sum Distinct Aggr value in QlikView https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225899#M848694 <HTML><HEAD></HEAD><BODY><P>Yes. that is what I used and it worked.&nbsp; The data model stinks...I know.</P></BODY></HTML> Thu, 16 Mar 2017 21:17:32 GMT cliff_clayman 2017-03-16T21:17:32Z Sum Distinct Aggr value https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225897#M848692 <HTML><HEAD></HEAD><BODY><P>I have a field (JobID) that has multiple records for various other data fields.&nbsp; One of the fields (JobCost) is displayed multiply times, but I just want to get a single value for it.&nbsp; How can I get the distinct JobID and get just a single value for the JobCost?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225897#M848692 cliff_clayman 2020-11-25T16:16:04Z Re: Sum Distinct Aggr value https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225898#M848693 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Sum(Aggr(Only(JobCost),JobID))</P><P></P><P>But it would probably better to remodel your data / change your load script to not duplicate your facts.</P></BODY></HTML> Thu, 16 Mar 2017 21:15:17 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225898#M848693 swuehl 2017-03-16T21:15:17Z Re: Sum Distinct Aggr value https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225899#M848694 <HTML><HEAD></HEAD><BODY><P>Yes. that is what I used and it worked.&nbsp; The data model stinks...I know.</P></BODY></HTML> Thu, 16 Mar 2017 21:17:32 GMT https://community.qlik.com/t5/QlikView/Sum-Distinct-Aggr-value/m-p/1225899#M848694 cliff_clayman 2017-03-16T21:17:32Z