Issue with aggr and rangesum

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Issue with aggr and rangesum

Anonymous — Wed, 12 Sep 2018 14:55:43 GMT

This is the article that inspired my current expression:

Recipe for a Pareto Analysis – Revisited

Re: Issue with aggr and rangesum

Anonymous — Wed, 19 Sep 2018 07:13:34 GMT

Is anybody able to help me with my issue?

topic Issue with aggr and rangesum in QlikView

Issue with aggr and rangesum

Re: Issue with aggr and rangesum

Re: Issue with aggr and rangesum