topic Recurring Clients over Periods in QlikView

Recurring Clients over Periods

Tue, 23 Mar 2010 03:23:32 GMT

I have several years of data with thousands of clients each. How can I create a set/chart/expression that will list the recurring clients if there are any? Thank you!

Recurring Clients over Periods

vgutkovsky — Tue, 23 Mar 2010 22:03:19 GMT

You need to do this in the script of course. I would say after you have loaded in the client table, make a new table, group by client_id, then code if (count(purchase#) > 1, 1, 0) as RepeatCustomerFlag. In this example, you would be tracking whether a customer has more than 1 purchase number, and if so, he is a repeat customer. Then, in your chart, you could use set the dimension to something like this: if(RepeatCustomerFlag=1,client_id) and suppress nulls.

Regards,

Recurring Clients over Periods

Wed, 24 Mar 2010 19:44:10 GMT

Thanks so much for the reply. I will try this out and let you know how it works.