Button that calculates number of customers until 80%

[Anonymous]

Hello,

I want to create a button that gives the number of customers that are needed to reach 80% of sales.

=if(sum(sales)/Sum(total sales)< 0.8, count(customer))

with this expression is giving me an error.

i hope you can help me.

[sunny_talwar]

Are you using the most recent version of QlikView 12? If you are, then you can use this sort of technique

Recipe for a Pareto Analysis – Revisited

[sunny_talwar]

In fact you might not need this, as you can use action related to Pareto Select

QlikView | Triggers | Pareto Select - YouTube

[Anonymous]

how about this ?

count({<customer={"=sum(sales)/sum(total sales)<0.8"}>} costumer)

[lironbaram]

hi

just create a button

and use the action pareto select

in the field put customer

in the expression : sum(sales)

in the percentage : 80

as in the picture below