Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aboumejjane
Contributor

identifying new customers each month

Hi Guys,

I'm trying to create a new field in my script where i'm defyining new and old customers.

Let's say we currentlty have 1 current customer in May. A month later a new customer is registered as a new customer.

I would like to create a field that registers new customers per month.

So in July the new customers in juni will automatically turn to CurrentCustomer.

How can I achieve the above?

I have three tables, one with dates fields, another with customerinfo, and last table is fact table. I need to create this field in my fact table.

Please find attached my script.

Regards,

Sam

9 Replies
aboumejjane
Contributor

Re: identifying new customers each month

can anyone help me with this?

sivarajs
Valued Contributor II

Re: identifying new customers each month

Try the script as

Load

If(Previous(Customer)=Customer,'Old','New') as Flag

Resident tablename order by Customer;

Not applicable

Re: identifying new customers each month

You could get which Customers are new through a set analysis formula, but if you want to create a field the the best option is to create a flag as Sivaraj suggested. Enclosed you can find an example

aboumejjane
Contributor

Re: identifying new customers each month

Hi Carlos,

Sorry for the late response. I've looked at your script. It's not not correct.

Since Customer A all ready made a purchase in may 2013 he cannot be registerd as a new customer in july.

Same goes for customer B who made a purchase in june, he cannot be registerd as a new customer in july.

What I would like to achieve is that I want to display a list of the current new customers per month. So in July when I get new data, I will have new customers for that month and the customers of the previous month are considerd as old.

note: I need to use both tables to achieve the above. The customer table and the date table.

Hope u can help.

Cheers!

iSam

aboumejjane
Contributor

Re: identifying new customers each month

can anyone help me with this issue?

aboumejjane
Contributor

Re: identifying new customers each month

I've been trying something new. I think im almost there.

Can some please help?

Attached is a new file.

Current customer A is still counted a new customer, which should not be the case.

Anyone any ideas?

aboumejjane
Contributor

Re: identifying new customers each month

I would appreciateany help

Not applicable

Re: identifying new customers each month

Sam,

The flag is supposed to help you so that you don't have to create all the possibilities in the script. Enclosed you cand find my earlier example with three listbox objects that I think do what you desire.

Hope it helps.

Ps. Sorry for not replying earlier but in the last weeks I've been very busy.

Not applicable

Re: identifying new customers each month

Hi,

Can you explain this script as to what happens.

I've tried using the same but not able to get proper results.

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 Untitled.png and the backend script.

Community Browser