Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How to prepare chart of rule 80:20?

Please help me to prepare table as result(Photo)

1 Solution

Accepted Solutions
sunny_talwar

Here you are

Capture.PNG

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)

View solution in original post

4 Replies
sunny_talwar

Do you have qv12 or above?

panwipa2528
Contributor III
Contributor III
Author

I user version 12.10.0.0

sunny_talwar

Here you are

Capture.PNG

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)