topic Re: Number of days between two dates in QlikView

Number of days between two dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table by customer and date of order and I would like to know for each client the time between his first order and his second, the second and the third and the third and more Could you help me? I tried to use the interval function but the result is not good

the result must be the following and an example is attached

Thank you for your help

Re: Number of days between two dates

trdandamudi — Wed, 15 Nov 2017 14:45:16 GMT

May be as below:

Re: Number of days between two dates

Anonymous — Wed, 15 Nov 2017 15:46:03 GMT

thanks not exactly because I need only synthesis for each step as in the following example for switching to a command to the second

Re: Number of days between two dates

Anonymous — Fri, 17 Nov 2017 07:57:46 GMT

Hello,

finally, I found my answer using the interval function and the minimum

= sum(aggr(Interval( min( [Date Commande],2)-min( [date],1),'D'),[Customer]))/count(distinct([Customer])