How to query a price using Set Analysis or other approach?

bill_mtc — Thu, 06 Nov 2014 03:23:00 GMT

Hi Guys!

I have this concern, since I don't have slow changing dimension of data, what I have is only a historical data where it only add new record whenever the price changes or have promotions. Please find the sample data below:

Item	Price	Start Date	End Date
A	100	10/1/2014	10/31/2014
A	150	9/1/2014
A	170	8/1/2013
A	200	1/1/2013

NOTE: Record with END DATE is promotional price, so when end date is no longer current or not equal to current date, then use the previous record.

Find below the Q&A:

Q&A:

1. Q: What is the price of Item A on 9/10/2014?

A: 150

2. Q: What is the price of Item A on 10/15/2014?

A: 100

3. Q: What is the price of Item A on 11/1/2014?

A: 150

Could values/answers above could be done using set analysis? Or should I do other approach? Please let me know, your help is much appreciated.

Regards,

Bill

topic How to query a price using Set Analysis or other approach? in QlikView

How to query a price using Set Analysis or other approach?