Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please go through the attached file
Please go through the attached file
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;
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: