Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

3-step conditional Join

Hi,

I have three tables (in XML) where I need to make a conditional join.

SalesTable

DateItem ID
2016-03-01A

ItemTable

ItemIDPriceListID
AX

PriceList

PricelistIDValidFromPrice
X2015-06-0120
X

2016-01-01

25
X2016-06-0130

I now need to make a join to see what price the item had on 2016-03-01. something like

use PriceList.Price where max(ValidFrom) < SalesTable.Date

Is it possible to get help here?

The goal is to get the relevant sales price attached to each sales line.

ie

DateItemIDPrice
2016-03-01A25

it needs to be outer joins, not all sales lines has an matching Item and not all Items has pricelistIDs

much appreciated.

1 Solution

Accepted Solutions
sunny_talwar

I think you need to look into IntervalMatch

View solution in original post

1 Reply
sunny_talwar

I think you need to look into IntervalMatch