Discussion Board for collaboration related to QlikView App Development.
There is no direct equivalent of vLookup as a function in QlikView, it would be better for you to explain what you want to achieve and perhaps post a small sample QVW with some explanation so we might be able to help. Whilst there is no vLookup, if we know what you want to do then we might be able to help.
Hi there is a function called lookup......please see the definition below. I have used this in the script to perform a lookup, I am not sure whether it works through the UI if thats what you need
Returns the value of fieldname corresponding to the first occurrence of the value matchfieldvalue in the field matchfieldname.
Fieldname, matchfieldname and tablename must be given as strings (e.g. quoted literals).
The search order is load order unless the table is the result of complex operations such as joins, in which case the order is not well defined.
Both fieldname and matchfieldname must be fields in the same table, specified by tablename. If tablename is omitted the current table is assumed.
If no match is found, null is returned.
lookup('Price', 'ProductID', InvoicedProd, 'pricelist')
You can use the exists() function to check for already loaded values:
tab1: ID, ID1, NAME, IF(EXISTS(ID), 1, 0) AS ID_REP FROM ...
Is this what you are looking for?
Take into account Anatoly's suggestion about performance in the load script. Anyway, the code will look like
LookUp('ID1', 'ID', ID1, 'tab1') AS ID_REP
Will return the value for ID1 when ID equals to current ID1, or null if there is no correspondence. It doesn't make much sense to me, though, because this is a value you already have loaded.