Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
you can use peek for this
if(customer_id = peek('customer_id'), 0, 1) as NewCustomerFlag,
order by customer_id,Order_date;
from your source;
u can use Ramon script and use that flag in ur chart object with NewCustomerFlag='0' and do the rest of calculations.