Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Primary Key Connections

Hello,

I just want to ask if this situation is possible in Qlikview.

I have 2 tables, 1st table consists of the following fields: Entry No. which is the primary key and other details, 2nd table, No. as primary key, From Entry No., To Entry No.

1st table:

Field Name
Entry No (PK)
other field details..

2nd table:

Field Name
No. (PK)
From Entry No
To Entry No

Now to link this two tables, not via No. but via condition.

Condition:

Entry No >= From Entry No and Entry No <= To Entry No

is this possible in Qlikview?

Thanks,

Donna

Tags (1)
4 Replies
Highlighted
jsn
Honored Contributor

Re: Primary Key Connections

Hi Donna,

Take a look at the IntervalMatch() function in QlikView. It should help you map a key value into an interval in another table.

Not applicable

Re: Primary Key Connections

is this applicable to .qvd?

jsn
Honored Contributor

Re: Primary Key Connections

Sure, the QVD is basically just another data source, lightning fast but working like any other table logically. They will not be loaded optimized though so it will be a bit slower than a straight up QVD load.

Not applicable

Re: Primary Key Connections

nvm. i think it's working

Community Browser