Counting customers who are new to a product

[pauledrich]

Hi and thanks in advance.

We have a customer database where each customer has a unique ID.

I am trying to identify customers who have never made a purchase of a product previously.

So if I wanted to calculate the number of sales to an existing or new customer these would be included.

Help with the expression or scrip would be very helpful.

Thanks again.

[swuehl]

Try maybe something like

count({<CustomerID = {"=sum(Sales)=0"}>} DISTINCT CustomerID)

to identify the Customers without Sales.

[pauledrich]

Thanks Swuehl - that seems to work although when I use in a pivot I'm loosing one of the dimensions which is a month.

What I would like to show is if a CustomerID was created in the past and had an agreement number, they would not be counted, if however the CustomerID was created in the past and had no agreement number then but had one created last week - I would be able to show that customer as a count for last week.

[#4]

Something similar but I'm getting an error.

Need to get a fix on this.

Im looking at new concepts that appear in the new start_period.

Kindly have a look at the snapshot which covers both the front (table box)

Ex: The "zein" concept though it is OLD it is marked as NEW. Kindly help and the backend script.

[#5]

Hi Shanmukha

Start new thread this will confuse people. Read following links.

http://community.qlik.com/docs/DOC-2380

http://community.qlik.com/docs/DOC-1290

[#6]

hi devang,

sorry for that, was browsing through forum and ended up posting that as i

encountered a similar problem.

I created a new thread and got a response as well.

It is good to be part of such an active community.

Thanks.