Pareto Diagram showing only 80% of the data

[PatricioH]

Hi everyone,

I was wondering if there is a way to make a pareto diagram to show the columns with the accumulative 80% and then spike to 100% with a "Others" column with the 20% left.

I have a Combined Chart where my first metric is Sum(MinTM) and Accumulative as the second metric with the expression "RangeSum(Above(Sum(MinTM), 0, RowNo())) / Sum(Total MinTM)". I tried limitations from dimension but nothing appears to happen.

[hic · Accepted solution]

Take a look at

https://community.qlik.com/t5/Design/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684