topic Re: What is the difference between Interval match and Apply map and Look up function? in QlikView

What is the difference between Interval match and Apply map and Look up function?

Wed, 25 Nov 2020 16:16:04 GMT

I did not find difference between Apply Map and interval Match.
Can any body please explain me.

Re: What is the difference between Interval match and Apply map and Look up function?

settu_periasamy — Sun, 06 Mar 2016 11:54:10 GMT

Hi,

Check it in the below qlikview help link.. Detailed explanation with example..

IntervalMatch

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm‌

ApplyMap

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/MappingFunctions/ApplyMap.htm‌

and here too..

IntervalMatch

Re: What is the difference between Interval match and Apply map and Look up function?

Peter_Cammaert — Sun, 06 Mar 2016 22:09:54 GMT

Applymap: uses a mapping table to translate a value into another value. If the first value couldn't be found in the mapping table, you can choose to return the original value or a parameter value.

Lookup: will search for a value in a column of an internal table and return the corresponding value from another column. Compare this to the Excel VLookup function. You could call it a more powerful but slower version of ApplyMap.

IntervalMatch: the simple version tries to match a set of discrete numerical values in a single field to all from-to ranges listed in an specific internal table. The end result will be a synthetic key that connects field values to all matching ranges. The extended version throws keys into the mix whose values have to match 1:1. IntervalMatch has no relation to the previous two functions.

Best,

Peter

Re: What is the difference between Interval match and Apply map and Look up function?

Peter_Cammaert — Sun, 06 Mar 2016 22:13:37 GMT

Oh and BTW, Lookup() and ApplyMap() are functions that may or may not be used while loading/calculating field data in a LOAD statement. Intervalmatch on the other hand is a LOAD statement prefix that turns a regular LOAD statement into a version with "side-effects" if you wish.

Re: What is the difference between Interval match and Apply map and Look up function?

Chanty4u — Mon, 14 Mar 2016 11:33:54 GMT

hi,

How To /Missing Manual (24 articles)

Apply Map Functions - Sources

Missing Manual - Map...using

Interval Match Feature/Function