Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Sum Distinct Aggr value

I have a field (JobID) that has multiple records for various other data fields.  One of the fields (JobCost) is displayed multiply times, but I just want to get a single value for it.  How can I get the distinct JobID and get just a single value for the JobCost?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Maybe like

=Sum(Aggr(Only(JobCost),JobID))

But it would probably better to remodel your data / change your load script to not duplicate your facts.

View solution in original post

2 Replies
Highlighted
MVP
MVP

Maybe like

=Sum(Aggr(Only(JobCost),JobID))

But it would probably better to remodel your data / change your load script to not duplicate your facts.

View solution in original post

Highlighted
Creator II
Creator II

Yes. that is what I used and it worked.  The data model stinks...I know.