Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

If Statement

Screenshot.png

In the Above table I need for the Breed to be calculated based on the Head Placed column. If the amount of any Breed is more than 80% of the total Head then that Breed will be used in naming, If not then it will be called "MIXED". Any assistance on this will be greatly appreciated.

1 Reply
Not applicable
Author

I think using aggr is your solution:

if(sum([head placed]) > sum(aggr(sum([head placed]), [group cd]))*80,'MIXED',[breed])