topic WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW? in App Development

WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?

priyasingh — Sat, 05 Apr 2025 19:07:17 GMT

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?

Re: WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?

Oleg_Troyansky — Sat, 05 Apr 2025 20:52:02 GMT

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!

Re: WHAT IS INTERVALMATCH AND HOW IT IS FUNCTION IN QLIKVIEW?

priyasingh — Sun, 06 Apr 2025 05:14:23 GMT

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