topic New customer grouping in QlikView

New customer grouping

aytacbas — Wed, 13 May 2015 09:11:12 GMT

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?

ramoncova06 — Wed, 13 May 2015 14:33:24 GMT

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 — Wed, 13 May 2015 14:46:16 GMT

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