topic Re: Interval in QlikView

Interval

Mon, 14 Aug 2017 05:30:14 GMT

Hi,

What would be the right expression to count interval of days from purchase date with the previous purchase date?

Basically I want to know the interval between purchase dates.

So what expression should I use to populate the above highlighted column to know total number days between two purchases?

Anil_Babu_Samineni — Mon, 14 Aug 2017 05:46:56 GMT

May be this?

LOAD *, Interval(Previous([Purchase Date])-[Purchase Date],'dd') as [Purchase Interval];

LOAD Sales_Id, Customer, Date(Date#([Purchase Date],'DD-MMM-YY')) as [Purchase Date] Inline [

Sales_Id, Customer, Purchase Date

1, Mr Smith, 26-Jul-17

2, Mr Smith, 06-Jul-17

3, Mr Smith, 26-Jun-17

4, Mr Smith, 08-May-17

5, Mr Smith, 04-Apr-17

6, Mr Smith, 29-Mar-17

7, Mr Smith, 28-Feb-17

];

Anil_Babu_Samineni — Mon, 14 Aug 2017 05:57:45 GMT

Or this? Front end