Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
wycliff4112
New Contributor

Vendor Count

Hi

Am trying to write a formula that will count the number of vendors whose total spend make up 80% of total spend.

The formula I have now for 80% spend is

     Sum([Invoice Amount USD])*0.8

Count of Vendors formula:

     Count(distinct([Harmonized Supplier Name]))

The vendors are sorted using their spend from largest to lowest.

The essence of this formula am seeking is for me to know how many vendors make up 80% of total spend.

thanks

Tags (1)
7 Replies

Re: Vendor Count

This might be a good place to start

Recipe for a Pareto Analysis – Revisited

wycliff4112
New Contributor

Re: Vendor Count

Is there one for Qlik Sense? I noticed that these are all for Qlik View. Kindly advise

Re: Vendor Count

This works for QlikView and Qlik Sense

wycliff4112
New Contributor

Re: Vendor Count

Thank you for your response. When I add the formula, I do not have the Desc option as it is not recognized. Additionally although the formula works, I get a bad class name error.

Formula: Background Color expression

If([Pareto Class] = 'A', LightGreen(),If([Pareto Class] = 'C', LightRed(), If([Pareto Class] = 'B', Yellow())))

Error.PNG

And Pareto

If([Exclusive Percentage]<= 0.8, 'A', If([Exclusive Percentage] <= 0.9, 'B', 'C'))

Error2.PNG

I am also trying to create a KPI that Counts the number of Vendors within Pareto Class A but cannot get it to work.

count(distinct({<'[Exclusive Percentage]' <= {0.8}>}[Harmonized Supplier Name]))

What is wrong with this formula?

Re: Vendor Count

What exactly are you doing? Can you share a sample to look at?

wycliff4112
New Contributor

Re: Vendor Count

I built the Pareto and it works even with the Bad Field Names. I cannot create a KPI to count the number of vendors within Pareto Class A.

Pareto.PNG

Re: Vendor Count