topic Re: Using the IntervalMatch Function in QlikView

Using the IntervalMatch Function

Tue, 18 Sep 2012 10:29:55 GMT

How to Get the Actual_Rate between using the From_Balance and To_Balance.

chematos — Tue, 18 Sep 2012 14:30:19 GMT

something like that:

Table:

load * inline[

Id, From_Balance , To_Balance

1, -0.1, 4999999

2, 50000000, 999999999

....

]

inner join intervalmatch(Balance)

load From_Balance , To_Balance

from table;

Thu, 11 Oct 2012 13:18:53 GMT

I got through this script..,

Rate_Slab:

LOAD

FROM_BALANCE,

TO_BALANCE,

INT_TYPE,

CCY,

ACTUAL_RATE

FROM

C:\Users\Administrator\Downloads\Rate_Matrix2.xls

(biff, embedded labels, table is [Rate Slab$]);

Client_Data:

LOAD ClientNo,

INT_TYPE,

CCY,

Balance,

FROM

C:\Users\Administrator\Downloads\Rate_Matrix2.xls

(biff, embedded labels, table is [Client Data$]);

Left Join(Rate_Slab)

IntervalMatch(Balance) Load FROM_BALANCE+1,

TO_BALANCE

Resident Rate_Slab

Where CCY='PKR' and (INT_TYPE='ISI' or INT_TYPE='PLS');