Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
This is the article that inspired my current expression:
Is anybody able to help me with my issue?