WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?

[priyasingh]

SALES:
LOAD * INLINE [

ORDER, PRODUCT, QTY, SALES PRICE
001, A, 250, 12.56
002, B, 40, 35.67
003, C, 900, 56.8
004, D, 579, 66.90
005, E, 279, 765
006, F, 467, 446
007, G, 743, 67
008, H, 378, 68.9
009, I, 904, 12.4
];

DISCOUNT:
LOAD * INLINE [

MINQTY, MAXQTY, DISCOUNT
4, 100, 27.9%
5, 200, 29.4%
76, 400, 12.7%
78, 455, 9.8%
86, 566, 41.9%
33, 342, 90.7%
];

JOIN IntervalMatch(QTY)
LOAD MINQTY, MAXQTY, DISCOUNT;


In this why I'm using interval match ? can i use any other function to get the result ? what is the importance of interval match?

[Oleg_Troyansky · Accepted solution]

Hi Priya,

Yes, the Interval Match in your example is used the way it should be used - to associate attributes (discount) that are defined for ranges of numbers (min-max) with distinct numbers (Qty). There is no other good way of associating them. 

You can read more about Interval match and about other QlikView development techniques in my book QlikView Your Business. Since you use QlikView, it's a perfect book for you. It will take you from the beginners' material to very deep advanced development techniques.

Good luck!

[priyasingh]

and why we are using resident load, why not preceding load ?bcz preceding load is better than resident load.