topic Differences in QlikView

Differences

prma7799 — Wed, 11 Feb 2015 11:10:35 GMT

Hi All,

what is difference between interval match and apply map?

Thanks

Prashant

Re: Differences

alexandros17 — Wed, 11 Feb 2015 11:13:09 GMT

Intervalmatch places values froma a table into corresponding intervals of a second table, while apply map places a field from a first table into a second table field (Not a Range of values - Interval)

take a look to the help for other details

Hope it helps

Re: Differences

avinashelite — Wed, 11 Feb 2015 11:15:53 GMT

apply map will match for that particular ID and get you the result.

table1:

maaping load

key,name

1,A

2,B

table2:

key,dept

1,XX

2,YY

when you use apply map

load applymap('table1',key) as name,

key,

dept

output

name,key,dept

A,1,XX

B,2,YY

interval will try to match for a range of values like from 0 to 5 its will search if any value is found it will provide the result

Re: Differences

Wed, 11 Feb 2015 11:32:23 GMT

Hi,

On broad line;

IntervalMatch() function is like matching the ranges and fetching them.

ApplyMap (with Mapping Load) acts like 'Lookup' in excel.

More info on both :

http://community.qlik.com/thread/93674 : IntervalMatch

http://community.qlik.com/thread/98764 : ApplyMap

Hope it helps!

Cheers !