Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This might be a good place to start
Is there one for Qlik Sense? I noticed that these are all for Qlik View. Kindly advise
This works for QlikView and Qlik Sense
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())))
And Pareto
If([Exclusive Percentage]<= 0.8, 'A', If([Exclusive Percentage] <= 0.9, 'B', 'C'))
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?
What exactly are you doing? Can you share a sample to look at?
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.