Discussion Board for collaboration related to QlikView App Development.
Hope you are well.
Struggling where to start with one
I have this data ( small sample )
And I am trying to populate the DEFAULT RATE from ICA_RATE below.
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.