topic Re: Order date difference in QlikView

Order date difference

Wed, 25 Nov 2020 16:16:04 GMT

How to find different in order days

i want to find out difference in order date..like (second order date)-(max order date)

example;max order date-second order date .

customer id Product Order date

1 ear phone 17/1/2015

1 Shirt 8/5/2015

8/5/2015-17/1/2015 = if they are in days then diff days or months

-----------------------------------------------------

2 Book 9/9/2015

2 Watch 11/9/2015

11/9/2015-9/9/2015=

-----------------------------------------------------------

3 Doumble 6/2/2016

3 Keyboard 2/1/2016

2/1/2016-6/2/2016 ==

PFA

Re: Order date difference

rido1421 — Thu, 01 Dec 2016 12:10:14 GMT

Hi John

Are you trying to find the difference in order dates between Products and customers?

eg. customer 1 ordered a "Ear phone" on 17/1/2015 , when last did customer 1 order "Ear Phone"

You would expect to get the previous order date and then Orderdate-PreviousOrderdate = Amount of Days

is this what you are looking for?

Re: Order date difference

ElizaF — Thu, 01 Dec 2016 12:17:52 GMT

See the attached file.

I hope to help you!

Re: Order date difference

Thu, 01 Dec 2016 12:17:58 GMT

i want to find out difference in order days .

but that order should be second order-max order.

my logic should be.

second orderdate -max order date of that customer id.

Re: Order date difference

Anonymous — Thu, 01 Dec 2016 12:21:09 GMT

hi,

suppose you have a dates like EndDate and StartDate.,

you can calculate the difference between the both the Date fields like as fallows,

EndDate-StartDate

then it will gets the difference between startdate and enddate.

Re: Order date difference

Anil_Babu_Samineni — Thu, 01 Dec 2016 12:34:18 GMT

Try Like this to get Days between Condition

NetWorkDays(Date(Aggr(Min(OrderDate),[Customer No]),'DD/MM/YYYY') - Date(Aggr(Max(OrderDate,2),[Customer No]),'DD/MM/YYYY'),0)

I got this, Are you happy this O/P

Re: Order date difference

rido1421 — Thu, 01 Dec 2016 12:50:35 GMT

See if this helps...

Re: Order date difference

Thu, 01 Dec 2016 12:51:05 GMT

Hi anil,

I did this. max order date-min order date. it ok is getting some difference.

but my requirement is max order date - second order date of a customer i want this difference others as zero

max order date-second order date others er difference should show as zero

Re: Order date difference

Thu, 01 Dec 2016 13:02:26 GMT

Hi Ridhaa,

Thanks..but i want second order date not min order date like

=max order date-second order date not as max order-min order

plz..