Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmac1971
Contributor II

Ranking Suppliers

Lets say I have a list of PO's, over 30,000, into the company for the last year, covering around 6500 parts.  Some of the parts have up to 4 suppliers and I want to quickly show no suppliers, COUNT(DISTINCT Vendor) and then show the average price for each of the vendors in a simple table.  What is the best way to go about this.  I've been looking at FirstSortedValue, and ranking but haven't figured it out yet?  Any ideas?

5 Replies
maleksafa
Valued Contributor

Re: Ranking Suppliers

can you share a sample document?

dmac1971
Contributor II

Re: Ranking Suppliers

Sorry wont be able to do this, but I'm sure someone else will have done something similar in the past.

Not applicable

Re: Ranking Suppliers

Hi Dermot,

If you just need a simple table to view this data,then you can use Table chart where you can sort and use the count function in expression along with the Avg price field.

Regards,

Barathiraja

dmac1971
Contributor II

Re: Re: Ranking Suppliers

See attached sample QV document.  This shows a list of parts each of which can have up to 10 suppliers.

I'd like to be able to show the following :

Item NoSupplier 1QtyAvg PriceSupplier 2QtyAvg PriceSupplier 3QtyAvg Price
juraj_misina
Valued Contributor

Re: Re: Re: Ranking Suppliers

I didn't manage to get it into one row per [Item] (FirstSortedValue() returns Null() if more values share the first rank, Rank() trials only worked for the first Vendor/Qty/Avg Price). But maybe this solution using dimension limits will suit you.

Community Browser