Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
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


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


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


2 Replies

See attached example.

talk is cheap, supply exceeds demand
Not applicable

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.