How to prepare chart of rule 80:20?

[panwipa2528]

Please help me to prepare table as result(Photo)

[sunny_talwar]

Do you have qv12 or above?

[panwipa2528]

I user version 12.10.0.0

[BalaBhaskar_Qlik]

May be try these, for your chart type:

https://community.qlikview.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis

https://community.qlik.com/thread/32008

[sunny_talwar · Accepted solution]

Here you are

Dimension

=If(Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())) / Sum(Total Sales), (Product, (=Sum(Sales), Desc))) <= 0.8099, '80%', '20%')

Expression

!

Sum(Sales)

Count(Product)