"Less than" matching in Apply Map

Wed, 27 May 2015 08:28:17 GMT

Hi,

Is it possible to use some sort of approx matching in apply maps? Basically what I want is to match on dates, but sometimes the date in my main table isn't present in the mapping table, so I would want to take the closest date in the past and use the value against that. Is this possible? Doesn't necessarily have to be done with apply map if there is a better option.

Thanks

Re: "Less than" matching in Apply Map

john_s_w_wood — Wed, 27 May 2015 08:38:25 GMT

I think you may have a couple of options

1. Use interval match functionality to apply date ranges.(See QV Help) This could possibly be built dynamically using the date list to determine start and end date ranges using the previous function.

2. Use the Autogenerate functionality to build a continuous list of dates - see Master Calendar elsewhere.

Ive highlighted the key words to look for in help or the community but if you attached some sample data I or others could look at a solution for you.

KRegs John

topic Re: "Less than" matching in Apply Map in QlikView

"Less than" matching in Apply Map

Re: "Less than" matching in Apply Map