topic Re: How to compare last date price? in QlikView https://community.qlik.com/t5/QlikView/How-to-compare-last-date-price/m-p/297846#M110475 <HTML><HEAD></HEAD><BODY><P>arunreddy,</P><P></P><P>Here's one way to do it.&nbsp; You should add 2 columns to the data model that contain the last and 2nd last purchase dates that permit you to do a sum(if(...)) in the interface.</P><P></P><P>Karl</P></BODY></HTML> Mon, 23 Jan 2012 20:09:50 GMT pover 2012-01-23T20:09:50Z How to compare last date price? https://community.qlik.com/t5/QlikView/How-to-compare-last-date-price/m-p/297845#M110474 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>i need an expretion for this scenario,</P><P>i want to compare the latest purchase price with last purchase date.</P><P>Eg:if product purchase date is 12/2/2010 with price is 12000,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; last purchase date 5/2/2010.with price is 50000,</P><P></P><P></P><P></P><P>thanks</P><P>arunreddy</P></BODY></HTML> Mon, 23 Jan 2012 07:17:47 GMT https://community.qlik.com/t5/QlikView/How-to-compare-last-date-price/m-p/297845#M110474 Anonymous 2012-01-23T07:17:47Z Re: How to compare last date price? https://community.qlik.com/t5/QlikView/How-to-compare-last-date-price/m-p/297846#M110475 <HTML><HEAD></HEAD><BODY><P>arunreddy,</P><P></P><P>Here's one way to do it.&nbsp; You should add 2 columns to the data model that contain the last and 2nd last purchase dates that permit you to do a sum(if(...)) in the interface.</P><P></P><P>Karl</P></BODY></HTML> Mon, 23 Jan 2012 20:09:50 GMT https://community.qlik.com/t5/QlikView/How-to-compare-last-date-price/m-p/297846#M110475 pover 2012-01-23T20:09:50Z