Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
flygstolen_fred
Creator
Creator

Table link and intervalmatch

Hi,

I have SQL tables with Order and Invoice data but now I wanna link external data to the order data.

I think I need to use intervalmatch but I need to make sure that CustomerType and SegmentId column matching also.

I wanna add the external markups as Invoicelines to each order.

Any help are appreciated!

OrderIDOrderDateCustomerTypeSegmentID
12342016-05-13Organic4

InvoiceLineIDNameCodePriceCostOrderID
132234Samsung TVJSDKDY10008001234
23221Panasonic DVDPKKDLJ3002751234

External markups:

FromDateToDateCustomerTypeSegmentIDNameCodePriceCost
2016-01-012016-12-31Organic4KickbackKSSYBJ250
2016-01-01
2016-12-31
Referal2KickbackUIREKK100
3 Replies
sunny_talwar

Would you be able to share what you expected output is?

flygstolen_fred
Creator
Creator
Author

Thanks for trying to help.

I wanna add the markup item to the current order as a invoice line.


InvoiceLineIDNameCodePriceCostOrderID
132234Samsung TVJSDKDY10008001234
23221Panasonic DVDPKKDLJ3002751234
KickbackKSSYBJ2501234


flygstolen_fred
Creator
Creator
Author

Hi,

I wanna be able to OrderID and Product Name as a dimension and use SUM(Price) for example as a measure.

Anyone who can point me in the right direction?