topic Re: VLOOKUP command in excel in QlikView

VLOOKUP command in excel

Wed, 25 Nov 2020 16:16:04 GMT

Good Morning, I'm new to QlikView.
I need help, could someone answer the following question?

Is there any command in QlikView that does the same function or similar to the "VLOOKUP" command in excel

Thanks in advance

Re: VLOOKUP command in excel

devarasu07 — Wed, 24 May 2017 08:04:35 GMT

Hi,

Try to use qlikview Mapping load and apply map function (It's basically it is just a Excel kind lookup function)

Don't join - use Applymap instead

Hope this helps you

Thanks,Deva

Re: VLOOKUP command in excel

prma7799 — Wed, 24 May 2017 08:11:25 GMT

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

lookup( fieldname, matchfieldname, matchfieldvalue [, tablename] )

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.

Example:

lookup('Price', 'ProductID', InvoicedProd, 'pricelist')

Re: VLOOKUP command in excel

ramasaisaksoft — Wed, 24 May 2017 08:57:18 GMT

Hi Gonzalo,

--> Lookup()

--> Apply map()

both are help to you as it is Vlookup () in Excel

small difference is there in between them go through below link for better understanding with Examples.

LookUp, Apply Map, Group by, Select Distinct, Left Join: different techniques to build Flags | QlikView Help, Tips & Hin…

Re: VLOOKUP command in excel

ngulliver — Wed, 24 May 2017 09:20:07 GMT

Here's a link to Steve Dark's blog on how to get the best from ApplyMap which has far more potential uses than just a VLOOKUP command

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/