Primary Key Connections

[#1]

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

[Anonymous]

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.

[#3]

is this applicable to .qvd?

[Anonymous]

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.

[#5]

nvm. i think it's working