topic Help with Intervalmatch (I think) in QlikView

Help with Intervalmatch (I think)

hobanwashburne — Wed, 25 Nov 2020 16:16:04 GMT

I've put together some sample data similar to what I'm working on. In this example we ran a sales program where each participating customer received 10% off their purchases. Customer A participated from January thru May, customer B participated from August thru November.

The attached file contains two tables: One containing the invoices, the other containing the effective dates of the program for each customer. How do I apply a discount (or somehow identify) the invoices that fall within the date range for the given customer?

Thank you

Re: Help with Intervalmatch (I think)

aarkay29 — Fri, 24 Feb 2017 23:47:07 GMT

Please go through the attached file

Re: Help with Intervalmatch (I think)

MK_QSL — Sat, 25 Feb 2017 00:11:16 GMT

Add below code after loading control table in your script.

Left Join

IntervalMatch (InvDate, Customer)

Load StartDate, EndDate, Customer Resident Control;

Left Join (Invoices_Temp02)

Load * Resident Control;

Drop Table Control;

Re: Help with Intervalmatch (I think)

sumitjadhav — Mon, 27 Feb 2017 08:46:04 GMT

hi Scott,

Refer the below example to clear the concept of interval match in qlik view,

Try the below method:

StudentMarks:

LOAD * INLINE [

Minmarks, Maxmarks, Result

10, 30, Fail

35, 40, Pass

45, 60, Average

70, 80, Honour

];

Student_Details:

LOAD * INLINE [

Marks, Name

30, sam

40, tom

50, Don

70, Bob

80, Rob

60, maddy

];

Interval:

IntervalMatch(Marks)

LOAD Minmarks,Maxmarks

Resident StudentMarks;

output: