How to build one QVD link two interval match?

[SomebabyTina]

Dear Experts,

Hope everything is good for you, I am new to QlikSense.

There is one problem I meet, can you help me ? 

My question Is it possible to build such kind of data structure ?

I have a period_end_onhand QVD, there are two columns ( AGING_OF_PERIOD_END, AGE_OF_NEXT1Q).

I need to link "AGING_OF_PERIOD_END" to Aging_buckets QVD to get current report_header1, report_header2...

In the same time, I need to link "AGE_OF_NEXT1Q" to Aging_buckets QVD.

Multiple intervalmatch from one QVD

ps. There are two key (AGING_OF_PERIOD_END, INV_BUCKET) from period_onhand QVD to bucket QVD.

My Load script

SUBINVENTORIES:
LOAD
ORGANIZATION_ID &'-'& SUBINVENTORY_CODE as subinv_key,
ORGANIZATION_CODE as INV_ORG,
SUBINVENTORY_CODE as SUBINV,
LOCATION_CODE,
LOCATION_COUNTRY_CODE,
INVENTORY_BUCKET,
MATERIAL_ACCOUNT
FROM [lib://Data/ERP_SUBINVENTORIES.qvd]
(qvd);

map1:
mapping LOAD
ORGANIZATION_ID & SUBINVENTORY_CODE as ckey,
INVENTORY_BUCKET
FROM [lib://Data/ERP_SUBINVENTORIES.qvd]
(qvd);

AGING_BUCKETS:
LOAD
DAYS_START,
DAYS_TO,
BUCKET_NAME as INV_BUCKET,
REPORT_HEADING1,
REPORT_HEADING2,
num#(RESERVED_RATE,'#.#00') as RESERVED_RATE
FROM [lib://Data/ERP_AGING_BUCKETS.qvd]
(qvd);

N1_AGING_BUCKETS:
NoConcatenate LOAD
DAYS_START as N1_DAYS_START,
DAYS_TO as N1_DAYS_TO,
BUCKET_NAME as N1_INV_BUCKET,
REPORT_HEADING1 as N1_BUCKET_H1,
REPORT_HEADING2 as N1_BUCKET_H2,
num#(RESERVED_RATE,'#.#00') as N1_RESERVED_RATE
FROM [lib://Data/ERP_AGING_BUCKETS.qvd]
(qvd);

PERIOD_END_ONHAND:
LOAD
ORGANIZATION_ID &'-'& SUBINVENTORY_CODE as subinv_key,
SET_OF_BOOKS_ID,
ORGANIZATION_ID,
INVENTORY_ITEM_ID,
MPN,
ONHAND_QTY,
SUBINVENTORY_CODE,
LOCATOR_ID,
LOCATOR,
LOT_NUMBER,
ORGANIZATION_CODE,
ORGANIZATION_NAME,
INV_PERIOD,
STD_COST,
USD_COST,
USD_RATE,
PERIOD_YEAR,
PERIOD_NUM,
PERIOD_START_DATE,
SCHEDULE_CLOSE_DATE,
INV_PERIOD_OPEN,
ApplyMap('map1', ORGANIZATION_ID & SUBINVENTORY_CODE ,null()) As INV_BUCKET ,
LOT_ORIGINATION_DATE,
AGING_OF_PERIOD_END,
NEXT1Q_END_DATE,
(NEXT1Q_END_DATE-LOT_ORIGINATION_DATE) as AGE_OF_NEXT1Q,
NEXT2Q_END_DATE,
(NEXT2Q_END_DATE-LOT_ORIGINATION_DATE) as AGE_OF_NEXT2Q
FROM [lib://Data/ERP_PERIOD_END_ONHAND.qvd]
(qvd);

Left Join (PERIOD_END_ONHAND)
IntervalMatch ( AGING_OF_PERIOD_END, INV_BUCKET )
LOAD DAYS_START, DAYS_TO, INV_BUCKET Resident AGING_BUCKETS;

Left Join (PERIOD_END_ONHAND)
IntervalMatch ( AGE_OF_NEXT1Q, INV_BUCKET )
LOAD N1_DAYS_START, N1_DAYS_TO, N1_INV_BUCKET Resident N1_AGING_BUCKETS;

Error Message

I can compile successfully yesterday, but doesn't work now.

Dont' know why....

Best Regards,

Tina Lee 

[y_grynechko]

Hey,

I would really like to help you but you will need to help me understand you better first. 

What is the key field to connect PERIOD_END_ONHAND to AGING_BUCKETS and PERIOD_END_ONHAND  to N1_AGING_BUCKETS? 

[SomebabyTina]

Hi,

Thanks for your reply.

My key for first table is AGING_OF_PERIOD_END, INV_BUCKET

For second is .AGE_OF_NEXT1Q, INV_BUCKET.

Actually, I already have solution regarding this..

The solution was coming from IntervalMatch and Slowly Changing Dimensions.pdf guide.

Reference Doc : IntervalMatch Document