Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

QlikView and Salesforce Question

I have the following Load statement:

Load

ClientName

ProductName

PurchaseDate

PurchaseAmount

From ......QVD File.

Here is the Scenario:

     1.  Client A purchases Product 1 on 1/1/2013 and Product 2 on 2/1/2013 and so on. 

What I would like to accomplish is:

     1.  How long did it take Client A to purchase the Product 2nd, 3rd, etc after the first purchase.  This can be in days and everything is based on the first purchase. 

Does this make sense and can it be done easily.

David