interval match multiple joins

RogerG — Tue, 12 Jan 2021 02:37:53 GMT

Hello all,

I have a series of tables that I need to join together before bringing in the costs.

I have some flexibility in the table designs, but not much.

the output of the attached is

PD	BS	VCA	PROJ_PH	SUM(COST)
AG1	APROVED	EXA1	-	10000
AG1	APROVED	EXA2	-	10000
AG1	APROVED	-	1	10000
AG1	APROVED	-	2	10000
AG2	pENDING	EXA1	-	18000
AG2	pENDING	EXA2	-	18000
AG2	pENDING	-	1	18000
AG2	pENDING	-	2	18000

for some reason, the lines with proj_ph are put on their own lines.

If an "Exit Script" is added right before the interval match, the table looks like I want it, but the costs are not summed per the intervals they belong.

EXA1 should be with proj_ph 1

eXA2, proj_ph 2

any help is appreciated

topic interval match multiple joins in QlikView

interval match multiple joins