IntervalMatch function

[#1]

Hi,

Can somebody explain the functionality and use of IntervalMatch function along with an example?

What I have understood from Qlikview help is : IntervalMatch is used to link a discrete numeric value to one or more numeric intervals. Need some more insight in that. It woud be helpful if explained with some example.

Thanks in advance!

[#2]

Hi,

PFA Dacument..............Will help you

[#3 · Accepted solution]

Hey mate,

Was replying to an earlier post with the same requirement. See attached QVW

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

[israrkhan]

see an example on below link,

and a documents attached from qliktech training.

http://community.qlik.com/thread/12152

[sushil353]

Hi,

IntervalMatch is used to associate a single value to a range of values..

Attached is an example to understand this better.. check the script and output.

HTH

Sushil

[#6]

Thank you all for your responses & answers. Really helped a lot!

[jim_chan]

Hi Sushil, but there's synthetic key in your data model...

How to solve it?

[#8]

You can create a link-table to resolve it or simply rename the fields. However, you actually no need to remove the synthetic keys in this case.