Interval match??

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have the listed requirement. I want the part highlighted in BOLD in my chart. Can i use interval match if so how do I do it?

Thanks

Re: Interval match??

german24 — Mon, 13 Mar 2017 15:39:37 GMT

Hi,

try this...

Re: Interval match??

Mon, 13 Mar 2017 15:45:10 GMT

Sorry, did I miss the qvw???

Thanks

Re: Interval match??

aarkay29 — Mon, 13 Mar 2017 15:46:03 GMT

Rate:

Mapping Load * Inline [

Yrs, Rate

0 to 1, 0.9

1 to 3, 2.25

3 to 5, 4.05

];

Temp:

Load * Inline [

Term, Yrs

0-370, 0 to 1

371-1105, 1 to 3

1106-1831, 3 to 5

];

Table:

Load * Inline [

Name, Amount, Termdays

ABC, 100, 170

DEF, 200 , 1200

];

INNER Join(Table)

IntervalMatch (Termdays)

Load

SubField(Term,'-',1) as From,

SubField(Term,'-',2) as To

Resident

Temp;

Temp2:

Load

Name,Amount,Termdays,From&'-'&To as Term

Resident

Table;

Drop Table

Table;

Left Join(Temp2)

Load

Term,

Yrs

Resident

Temp;

Drop Table

Temp;

FinalTable:

Load

Name,Amount,Termdays,Amount*Rate as Fee;

Load

Name,Amount,Termdays,Term,Yrs,

ApplyMap('Rate',Yrs) as Rate

Resident

Temp2;

Drop Table

Temp2;

Re: Interval match??

german24 — Mon, 13 Mar 2017 16:02:04 GMT

QVW

Best regards,

German

topic Re: Interval match?? in QlikView

Interval match??

Re: Interval match??

Re: Interval match??

Re: Interval match??

Re: Interval match??