Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
is this applicable to .qvd?
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.
nvm. i think it's working