# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Top Suppliers for 80% Spend

Hello everyone,

I have these transactions data.

 Product Supplier Spend Product A Supplier 1 2000 Product A Supplier 2 1200 Product A Supplier 3 700 Product A Supplier 4 500 Product A Supplier 5 500 Product A Supplier 6 400 Product A Supplier 7 350 Product A Supplier 8 325 Product A Supplier 9 250 Product A Supplier 10 200 Product B Supplier 1 2000 Product B Supplier 2 1500 Product B Supplier 3 750 Product B Supplier 1 700 Product B Supplier 2 700 Product B Supplier 3 400 Product B Supplier 4 650 Product B Supplier 5 200 Product B Supplier 6 100 Product C Supplier 1 250 Product C Supplier 2 250 Product C Supplier 3 200 Product C Supplier 4 200 Product C Supplier 5 150

I would like to create this following report (in pivot table or table). I can't seem to get the last column, which is the count (distinct) of Suppliers contributing up to 80% of the spend for each Product.

 Product Spend # of Suppliers (Distinct) 80% Spend # of Suppliers (Distinct - 80% Spend) Product A 6425 10 5140 5 Product B 7000 6 5640 3 Product C 1050 5 840 3

1 Solution

Accepted Solutions
Honored Contributor III

## Re: Top Suppliers for 80% Spend

Check this if it can be of any help -

11 Replies
Valued Contributor III

## Re: Top Suppliers for 80% Spend

Hi Stewart,

Try this on Straight table:

Regards!

Honored Contributor III

## Re: Top Suppliers for 80% Spend

There are number of ways t o do that:

* Use dimension limits they are too fast and worth

* Use calculated dimension this is time consuming one.

Not applicable

## Re: Top Suppliers for 80% Spend

Sorry, I posted this question on a wrong forum. I'm actually using Qlik Sense (not Qlik View).

Valued Contributor III

## Re: Top Suppliers for 80% Spend

HI,

I am not sure how you work out the last column i..e the logic that is used.

Other than that you can use a use a straight table from charts.

Dimension would be Product.

Expressions

Spend = Sum(Spend)

# of suppliers = Count(DISTINCT Supplier)

80% of spend = SUM(Spend)*0.80

Mark

Honored Contributor III

## Re: Top Suppliers for 80% Spend

Moved to "New to Qlik Sense".

May you live in interesting times!
Honored Contributor III

## Re: Top Suppliers for 80% Spend

Check this if it can be of any help -

Honored Contributor II

## Re: Top Suppliers for 80% Spend

Hi Stewart,

Qlik Design Blog : Recipe for a Pareto Analysis | Qlik Community

Not applicable

## Re: Top Suppliers for 80% Spend

Wow, the formula looks quite complicated.

This is exactly what I needed. It works flawlessly. Thanks so much!

MVP

## Re: Top Suppliers for 80% Spend

I think this only works if the LOAD order of supplier is already listing the suppliers by Spend descending for every Product, like in your sample data, but I doubt that your real data will show the same property.