Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

can anyone help me with this?

sivarajs
Specialist II
Specialist II

Try the script as

Load

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

Resident tablename order by Customer;

Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

can anyone help me with this issue?

Anonymous
Not applicable
Author

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?

Anonymous
Not applicable
Author

I would appreciateany help

Not applicable
Author

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
Author

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.