Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

flygstolen_fred
New Contributor III

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
MVP
MVP

Re: Table link and intervalmatch

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

flygstolen_fred
New Contributor III

Re: Table link and intervalmatch

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


Highlighted
flygstolen_fred
New Contributor III

Re: Table link and intervalmatch

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?