Lookup Function

[#1]

Hi,

Now that the Lookup() function is gone, how do I do an easy lookup?

Unique ID	ColA	ColB	ColC
1	xxx	yyy	zzz
2	rrr	sss	ttt
3	uuu	vvv	www

Say I have id=2 and col='ColC'. How do I get to 'ttt' now without creating millions of mapping tables?

Thanks!

[rbecher]

Lookup() can be used in script only..

[#3]

Okay, so this won't work here...

[#4]

Can't believe such a simple function doesn't exist

[rbecher]

Right, I suggest to add a field with this lookup in script level..

[#6]

That won't be dynamic enough... Lookup is the simplest function ever, there must be a way to use it in QlikView?!

[rogerioqv]

Friend,

Analyze the peek command. I think it will solve your problem.

[rbecher]

You're on an aggregation level in chart. This is very different than on raw data level. I guess you can do something with set analysis and/or Aggr() but therefor one would need more information on the use case itself..

[its_anandrjs]

Check this from the help that may help you

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')

[rbecher]

Why not reading previous answers first?

[#11]

Peek is not supported expressions either.