topic Re: Find new customers in QlikView

Find new customers

dusasuman — Thu, 24 Sep 2015 06:30:50 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

Re: Find new customers

datanibbler — Thu, 24 Sep 2015 07:13:14 GMT

Hi Suman,

1) finding new customers is relatively easy - you can either extract using a NOT(EXISTS() clause to find out which vendors in the 2015_table are not in the 2014_table - or you can just OUTER join them, which will give you a lot of empty fields every time a vendor is not common to both tables. Then you could easily find out which are in the new table, but not in the old.

2) The TOTAL parameter will help you to find out about any individual vendor's contribution to the total (it ignores the dimension > vendor <) - I'm not sure how to create like a total of the top_100 vendors' contribution, but there certainly is a way to do it.

HTH

Best regards,

DataNibbler

Re: Find new customers

dusasuman — Fri, 25 Sep 2015 17:20:38 GMT

the req has changed now.

the requirement is like below. I have a dimension FiscalYear as a dimension it has a data from 2012 to 2015

Nw I want to show the count of new vendors by Year. for example need to show count of new Vendors in 2015 not exists in remaining years 2014,13,12.. For the year 2014 need to show the count of new vendors not falls in its below years 2013,12.. so on... Here Fiscal year is a dimension. Need to show year wise new vendors count achieved.

Can any one help me out..