topic Re: Assign standard Price-date in QlikView

Assign standard Price-date

ecabanas — Tue, 24 Nov 2015 12:32:58 GMT

Hi,

I have this sales table with itemid, date and amount:

Salesid	Date	Itemid	units	Amount	Price
A	10/01/2015	1	1	2	3
B	15/02/2015	2	1	4	4,2
C	15/03/2015	4	1	5	5,2

And a Standard Cost table ordered by itemid, from, to, and Cost

Itemid

From

To

Price

1

01/01/2015

31/01/2015

3

1

01/02/2015

28/02/2015

3,2

1

01/03/2015

31/03/2015

3,3

2

01/01/2015

31/01/2015

4

2

01/02/2015

28/02/2015

4,2

2

01/03/2015

31/03/2015

4,3

3

01/01/2015

31/01/2015

5

3

01/02/2015

28/02/2015

5,1

3

01/03/2015

31/03/2015

5,2

And in a set analisys I want to match the itemid and date and choose the correct standard cost:

Many thank's

Re: Assign standard Price-date

swuehl — Tue, 24 Nov 2015 12:40:34 GMT

HIC as written an excellent tech doc about slowly changing dimensions, like your price table:

IntervalMatch and Slowly Changing Dimensions