topic Re: Calculate most recent price point in QlikView https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397521#M484385 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 22 May 2013 18:28:20 GMT Gysbert_Wassenaar 2013-05-22T18:28:20Z Calculate most recent price point https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397520#M484384 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: verdana, geneva;">Greetings experts!</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">I am attempting to get most recent price per Location, SKU. The issue is that I do not have a fully populated price field I can easily use and I was hoping that there is some Set Analysis hacketry that could get us there.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">For each Date, Sku, Location price would be defined by a record of same, or preceding date, of the same SKU code and location.</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">In following example we're determining a price for the SKU 'ZYX4321', Location 2 on the date of 20130102</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;"><IMG __jive_id="41558" class="jive-image" alt="Date-Sku-Loc.png" src="https://community.qlik.com/legacyfs/online/41558_Date-Sku-Loc.png" /> </SPAN></P><P><SPAN style="font-family: verdana, geneva;">Since the records are ordered by the date, we would navigate up the list to find latest record with a price and matching SKU, Location</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;"><IMG __jive_id="41559" class="jive-image" alt="Date-Sku-Loc_Match.png" src="https://community.qlik.com/legacyfs/online/41559_Date-Sku-Loc_Match.png" /></SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">QVW with my attempted solution is attached. Any help or insights you might have are greatly appreciated!</SPAN></P><P></P><P><SPAN style="font-family: verdana, geneva;">D</SPAN></P><P><SPAN style="font-family: verdana, geneva;"><BR /></SPAN></P></BODY></HTML> Wed, 22 May 2013 17:35:47 GMT https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397520#M484384 2013-05-22T17:35:47Z Re: Calculate most recent price point https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397521#M484385 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Wed, 22 May 2013 18:28:20 GMT https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397521#M484385 Gysbert_Wassenaar 2013-05-22T18:28:20Z Re: Calculate most recent price point https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397522#M484386 <HTML><HEAD></HEAD><BODY><P>Thank you for the helpful answer Gysbert, unfortuntely, due to the constraints that are both long and boring I can not approach implementation in any other way than by using set analysis.</P></BODY></HTML> Wed, 22 May 2013 19:06:09 GMT https://community.qlik.com/t5/QlikView/Calculate-most-recent-price-point/m-p/397522#M484386 2013-05-22T19:06:09Z