Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
racer25
Contributor III
Contributor III

Join Question with Dates Between

Hi All,

Hope you are well.

Struggling where to start with one

I have this data ( small sample )

INSURER CODEINSURER BRANCHRISK CODEINCOME DATEPREMIUMCOMMISSIONACTUAL RATEDEFAULT RATE
M018100A00101/01/2018100010010%15%
M018100A00101/11/2017200036018%12%

 

And I am trying to populate the DEFAULT RATE from ICA_RATE below.

ICA_INSCODEICA_INSBRANCHICA INS_CODEICA RATEICA DATE
M018100A00115%01/07/2017
M018100A00112%01/10/2017
M018100A00115%31/12/2017

 

There can be many Insurer Codes and Risk Codes. The rate should be selected from Income Date in between the 2 dates or if nothing in between then today.

In my example it picked 15% as it was the last update and 12% as after 01/10/2017 but before the next updated date.

I know as much to think of Interval Match but little beyond that.

If anyone could help me out on this it would be very much appreciated.

Thanks

Rob 

 

Labels (2)
1 Reply