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