Issue with aggr and rangesum

[Anonymous]

Hello,

I wish to make a bar chart showing how many different Error Types make up 80% of the total errors happening to a number of different Equipment Types.

The expression I am currently using to create the bar chart is the following:

sum(Aggr(

If(Rangesum(Above(Count({1} Error_Type)/Count({1} total Error_Type),1,RowNo()))<0.8, '1',
'0'),
(Error_Type,(=Count({1} Error_Type),Desc))
))

When I choose to only show one Equipment type, it works. It simply counts how many different Error Types make up 80% of the total errors. However, when I choose to show all Equipment Types it does not work.

Do you have any idea of how to solve this?

I have attached an excel-file with my dataset and a qlikview-file with my graph as it looks now.

Thanks in advance!

[Anonymous]

This is the article that inspired my current expression:

Recipe for a Pareto Analysis – Revisited

[Anonymous]

Is anybody able to help me with my issue?