intervalmatch() ? use ?

[#1]

Hi

I am new to qlikview .i am not understanding intervalmatch function ?

what is intervalmatch() function ?

USE  of intervalmatch?

At what situation intervalmatch function is use?

Please help me

[tresesco]

Read this blog post : http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

[#3]

The IntervalMatch prefix is used to create a table matching discrete numeric values to one or more numeric intervals.

lets assume there is table

Student:

StName	Marks
AB	25
BA	40
CA	55
DA	60
EA	75

and we have a table for grades

Status:

Min	Max	Grade
0	29	Fail
30	45	Third
46	59	Second
60	74	First
75	100	Honors

now we can find Student grades by using IntervalMatch() by following script

intervalmatch(Marks) load Min,Max resident Status;

now Student's Grade is obtained by matching the Marks in the interval of minimum and Maximum value.

so when we create a table box for the grade of the student following table is obtained.

StName	Grades
AB	Fail
BA	Third
CA	Second
DA	First
EA	Honors

because 25 comes between the interval of 0-29 for that grades is fail.This is logic on which intervalmatch() works.