How to find new vendors

dusasuman — Thu, 24 Sep 2015 10:58:13 GMT

I have a vendors data based on Purchase date.

I have a data for 2014 and 2015.

1. Here I want to find the New vendors in 2015 who are not in 2014.. Here the dimension is Vendor. In metric I need to show 'Yes' as a value if he is a new vendor, else It should return 'No'..

2. And also I need to find the top 100 vendors contribution by Purchase value amount field . Let us take a scenario.

I have fields VendorName, ItemGroup and PurchaseValue . Here each ItemGroup will lhave multiple Vendors.

I need to show a chart ItemGroup as a dimension and 2 Metrics as 1.Top 100 vendors amount 2. Remaining vendors amount contribution.

Help me out.

regards

suman

topic How to find new vendors in QlikView

How to find new vendors