topic Classifiy new/old Customers in QlikView

Classifiy new/old Customers

Tue, 23 Feb 2010 16:16:35 GMT

Hi,

I have a table that shows me the customer, orderdate, amount

How can I classifiy based on the current year if a customer is a new customer (orders only in 2010) or an old customer (orders before 2010)

Thanks for your help.

Kind Regards.

Aloah

Tue, 23 Feb 2010 16:27:34 GMT

You would probably need a combination of the TOTAL command and Set Analysis. Something like this:

Sum({<orderdate={'<$(=MakeDate(Year(Today())))'}>} TOTAL <Customer> Amount)

That should give you the total amount of sales prior to the current year. If that is greater than zero, then they are repeat customers.

EDIT: I wasn't sure how you were handling selections, so I left it as the default (respect selections).

Fri, 05 Mar 2010 15:10:42 GMT

Hi,

I'm trying to get a field that shows be, based on the selected year if a selected customer is
a new or old customer.

E.g. I select 2009, bar chart show me sales amount for new customers = 40%, old customers = 60%.

Thanks