Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
aytacbas
New Contributor II

New customer grouping

Hi All;

I've a table  and it has 3 values customer_id, Order_id and Order_date ;

I want to find  new customers rate daily


How can I do that?

2 Replies
ramoncova06
Valued Contributor III

Re: New customer grouping

you can use peek for this

load

if(customer_id = peek('customer_id'), 0, 1) as NewCustomerFlag,

customer_id,

Order_id,

Order_date

order by customer_id,Order_date;



load

customer_id,

Order_id,

Order_date

from your source;


buzzy996
Honored Contributor II

Re: New customer grouping

u can use Ramon script and use that flag in ur chart object with NewCustomerFlag='0' and do the rest of calculations.