topic Re: Re: Lookup Function in QlikView

Lookup Function

Tue, 10 Jun 2014 12:53:29 GMT

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!

Re: Lookup Function

anbu1984 — Tue, 10 Jun 2014 12:58:10 GMT

Try this

If(id=2,pick(match(col,'ColA','ColB','ColC'),ColA,ColB,ColC))

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 12:58:16 GMT

Hi (number),

why not just using QlikView's Lookup() function?

- Ralf

Re: Lookup Function

Tue, 10 Jun 2014 13:00:20 GMT

Because I don't think Lookup exists anymore in my version?

Thanks!
Oli

Re: Lookup Function

Tue, 10 Jun 2014 13:01:32 GMT

That's just hardcoding it... What if id=24343 and col=ColXY?

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 13:05:27 GMT

Why? Which version?

Re: Lookup Function

Tue, 10 Jun 2014 13:06:24 GMT

As far as I know the lookup function still exists?

Re: Lookup Function

Tue, 10 Jun 2014 13:16:16 GMT

QV11... Doesn't come up!

Thanks

Oli

Re: Lookup Function

Tue, 10 Jun 2014 13:16:29 GMT

See above...

Re: Lookup Function

Tue, 10 Jun 2014 13:21:16 GMT

That's actually really strange, I can see it in my help menu but I see the same problem you do...

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 13:21:39 GMT

Lookup() can be used in script only..

Re: Lookup Function

Tue, 10 Jun 2014 13:27:13 GMT

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

Re: Lookup Function

Tue, 10 Jun 2014 13:27:42 GMT

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

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 13:39:10 GMT

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

Re: Lookup Function

Tue, 10 Jun 2014 13:49:59 GMT

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

Re: Lookup Function

rogerioqv — Tue, 10 Jun 2014 14:00:20 GMT

Friend,

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

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 14:17:39 GMT

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..

Re: Lookup Function

its_anandrjs — Tue, 10 Jun 2014 14:43:59 GMT

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

Re: Lookup Function

rbecher — Tue, 10 Jun 2014 14:46:22 GMT

Why not reading previous answers first?

Re: Lookup Function

Tue, 10 Jun 2014 15:20:19 GMT

Peek is not supported expressions either.