topic QlikView and Salesforce Question in QlikView https://community.qlik.com/t5/QlikView/QlikView-and-Salesforce-Question/m-p/595208#M685047 <HTML><HEAD></HEAD><BODY><P>I have the following Load statement:</P><P></P><P>Load</P><P>ClientName</P><P>ProductName</P><P>PurchaseDate</P><P>PurchaseAmount</P><P>From ......QVD File.</P><P></P><P>Here is the Scenario:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; Client A purchases Product 1 on 1/1/2013 and Product 2 on 2/1/2013 and so on.&nbsp; </P><P></P><P>What I would like to accomplish is:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; How long did it take Client A to purchase the Product 2nd, 3rd, etc after the first purchase.&nbsp; This can be in days and everything is based on the first purchase.&nbsp; </P><P></P><P>Does this make sense and can it be done easily. </P><P></P><P>David</P></BODY></HTML> Fri, 31 Jan 2014 15:33:35 GMT 2014-01-31T15:33:35Z QlikView and Salesforce Question https://community.qlik.com/t5/QlikView/QlikView-and-Salesforce-Question/m-p/595208#M685047 <HTML><HEAD></HEAD><BODY><P>I have the following Load statement:</P><P></P><P>Load</P><P>ClientName</P><P>ProductName</P><P>PurchaseDate</P><P>PurchaseAmount</P><P>From ......QVD File.</P><P></P><P>Here is the Scenario:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; Client A purchases Product 1 on 1/1/2013 and Product 2 on 2/1/2013 and so on.&nbsp; </P><P></P><P>What I would like to accomplish is:</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; How long did it take Client A to purchase the Product 2nd, 3rd, etc after the first purchase.&nbsp; This can be in days and everything is based on the first purchase.&nbsp; </P><P></P><P>Does this make sense and can it be done easily. </P><P></P><P>David</P></BODY></HTML> Fri, 31 Jan 2014 15:33:35 GMT https://community.qlik.com/t5/QlikView/QlikView-and-Salesforce-Question/m-p/595208#M685047 2014-01-31T15:33:35Z