topic Price History Comparison in QlikView https://community.qlik.com/t5/QlikView/Price-History-Comparison/m-p/410913#M152975 <HTML><HEAD></HEAD><BODY><P>I am trying to build a report showing based on the same table to compare the purchase price of items based on selected month and comparing these items to its previous entry.</P><P></P><P>For example:</P><P>Month and year selected - Feb 2013</P><P></P><P>A - $1</P><P>C - $3</P><P>D - $2</P><P></P><P>How can I compare side by side items A, C and D's last purchase price as they might be bought in different months?</P><P></P><P>For example:</P><P>A - last purchase in Jan 2013</P><P>C - last purchase in Dec 2012</P><P>D - last purchase in Jan 2011</P><P></P><P>In my report, i have put </P><P>if(previous("ItemNo")=("ItemNo"),previous("Document_No"),'Most Recent') as RecentFlag</P><P></P><P>but it only returns the unique item bought for the month if there is any replications in the items bought in the same month</P><P></P><P>Can anyone help me on this?</P></BODY></HTML> Wed, 06 Mar 2013 06:24:22 GMT 2013-03-06T06:24:22Z Price History Comparison https://community.qlik.com/t5/QlikView/Price-History-Comparison/m-p/410913#M152975 <HTML><HEAD></HEAD><BODY><P>I am trying to build a report showing based on the same table to compare the purchase price of items based on selected month and comparing these items to its previous entry.</P><P></P><P>For example:</P><P>Month and year selected - Feb 2013</P><P></P><P>A - $1</P><P>C - $3</P><P>D - $2</P><P></P><P>How can I compare side by side items A, C and D's last purchase price as they might be bought in different months?</P><P></P><P>For example:</P><P>A - last purchase in Jan 2013</P><P>C - last purchase in Dec 2012</P><P>D - last purchase in Jan 2011</P><P></P><P>In my report, i have put </P><P>if(previous("ItemNo")=("ItemNo"),previous("Document_No"),'Most Recent') as RecentFlag</P><P></P><P>but it only returns the unique item bought for the month if there is any replications in the items bought in the same month</P><P></P><P>Can anyone help me on this?</P></BODY></HTML> Wed, 06 Mar 2013 06:24:22 GMT https://community.qlik.com/t5/QlikView/Price-History-Comparison/m-p/410913#M152975 2013-03-06T06:24:22Z