Help with Intervalmatch (I think)

[hobanwashburne]

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

[aarkay29 · Accepted solution]

Please go through the attached file

[MK_QSL]

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;

[sumitjadhav]

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: