Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

intervalmatch

I have a problem with de combination orderdate per product and to combine the salesprice with the right costprice.

Example:

Tabel 1 :

product date from date till costprice

a 1-1-2010 28-2-2010 5,50

a 1-3-2010 20-3-2010 9,90

b 11-11-2009 18-2-2010 1,25

b 19-2-2010 31-3-2010 2,20

Tabel 2:

Order Orderdate Orderline product salesprice

98001 01-01-2010 1 a 12,50

98001 01-01-2010 2 b 5,90

98002 01-03-2010 1 a 15,50

IntervalMatch(orderdate) gives double records because there are more products per date selection.

Please can someone give me the right solution?

Thanks

2 Replies
prieper
Master II
Master II

Have a look into the extended syntax of the IntervalMatch

sample is attached (already joining the tables together i/o to avoid a synthetic key)

HTH
Peter

Not applicable
Author

Thanks Peter