topic Primary Key Connections in QlikView

Primary Key Connections

Wed, 05 Dec 2012 02:30:50 GMT

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

Re: Primary Key Connections

Anonymous — Wed, 05 Dec 2012 04:37:18 GMT

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.

Re: Primary Key Connections

Wed, 05 Dec 2012 06:36:32 GMT

is this applicable to .qvd?

Re: Primary Key Connections

Anonymous — Wed, 05 Dec 2012 06:39:14 GMT

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.

Re: Primary Key Connections

Wed, 05 Dec 2012 06:48:13 GMT

nvm. i think it's working