topic Subtracting data from a certain timestamp. in QlikView https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234015#M85505 <HTML><HEAD></HEAD><BODY><P>Thanks, that seem to do the trick.</P></BODY></HTML> Mon, 26 Jul 2010 22:15:02 GMT 2010-07-26T22:15:02Z Subtracting data from a certain timestamp. https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234013#M85503 <HTML><HEAD></HEAD><BODY><P>I have three columns timestamp, feed, click_count. I need to subtract the click_count from the click_count five minutes earlier</P><P>Timestamp Feed click_count</P><P>7/15/2010 00:05 BraveNet 1</P><P>7/15/.2010 00:10 Bravenet 4</P><P>I need a way to create another column to calculate the difference between the click at 00:05 and the click at 00:10 for the answer t be 3 clicks.</P><P>I am pulling this data from a qvw.</P><P></P><P>Thanks LIZ</P><P></P></BODY></HTML> Mon, 26 Jul 2010 21:16:45 GMT https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234013#M85503 2010-07-26T21:16:45Z Subtracting data from a certain timestamp. https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234014#M85504 <HTML><HEAD></HEAD><BODY><P>Look for previous() function in a " load resident;" in the help, there is a good example there. You can also use the peek() function.</P></BODY></HTML> Mon, 26 Jul 2010 21:26:00 GMT https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234014#M85504 fernandotoledo 2010-07-26T21:26:00Z Subtracting data from a certain timestamp. https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234015#M85505 <HTML><HEAD></HEAD><BODY><P>Thanks, that seem to do the trick.</P></BODY></HTML> Mon, 26 Jul 2010 22:15:02 GMT https://community.qlik.com/t5/QlikView/Subtracting-data-from-a-certain-timestamp/m-p/234015#M85505 2010-07-26T22:15:02Z