intervalmatch() ? use ?

Thu, 21 Aug 2014 11:36:19 GMT

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

Re: intervalmatch() ? use ?

tresB — Thu, 21 Aug 2014 11:37:32 GMT

Thu, 21 Aug 2014 11:58:46 GMT

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:

and we have a table for grades

Status:

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.

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