Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies