Discussion Board for collaboration on QlikView Scripting.
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.
Now to link this two tables, not via No. but via condition.
Entry No >= From Entry No and Entry No <= To Entry No
is this possible in Qlikview?
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