If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Good Day to Everyone!
I want to calculate days between each purchase made by distinct customer.I have 3 fields, Order ID, Customer ID, Order Date.
Order ID is unique field here
LOAD * INLINE [
Order ID|Customer ID|Order Date
](delimiter is |);
So what makes it difficult for me, some customers have made only 1 purchase, some have made 3 and some have made 2. I need to calculate days between purchases. Please advise how I can do that?
Try script as attached.
I've derived date diff by customer and overall date diff.
View solution in original post