Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Highlighted
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