Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate most recent price point

Greetings experts!

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.

For each Date, Sku, Location price would be defined by a record of same, or preceding date, of the same SKU code and location.

In following example we're determining a price for the SKU 'ZYX4321', Location 2 on the date of 20130102

Date-Sku-Loc.png

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

Date-Sku-Loc_Match.png

QVW with my attempted solution is attached. Any help or insights you might have are greatly appreciated!

D


2 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

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.