JOIN With Date Ranges and Future

[racer25]

Hi All,

Hope you are well.

Struggling where to start with one

I have this data ( small sample )

INSURER CODE	INSURER BRANCH	RISK CODE	INCOME DATE	PREMIUM	COMMISSION	ACTUAL RATE	DEFAULT RATE
M018	100	A001	01/01/2018	1000	100	10%	15%
M018	100	A001	01/11/2017	2000	360	18%	12%

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

ICA_INSCODE	ICA_INSBRANCH	ICA INS_CODE	ICA RATE	ICA DATE
M018	100	A001	15%	01/07/2017
M018	100	A001	12%	01/10/2017
M018	100	A001	15%	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 

[Brett_Bleess]

Best I have given I am not very good with the developer questions would be to check out the Design Blog area, you may find some examples/information there that might give you some further ideas:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Sorry I do not have anything better.  This post will kick this back up too, so someone else may see it and have some other suggestions, but definitely have a search in the Design Blog area, as I think you may find something there to help, I am just not quite sure what you need on this one though.

Regards,
Brett