topic Use of LOOKUP function in QlikView

Use of LOOKUP function

Tue, 08 Jun 2010 07:34:11 GMT

Hi All,

If any of you know about use of 'LOOKUP' funtion then please let me know.Help file information is not enough.

Thanks & Regards

Jai

Use of LOOKUP function

Tue, 08 Jun 2010 07:53:21 GMT

Maybe you try to tell what you want it to lookup for you?

Regards

Jürg

Use of LOOKUP function

Tue, 08 Jun 2010 08:10:45 GMT

Hi,

Thanks for your kind reply.Actually I am doing study in QlikView functions.In that I could not able to get the usage for 'Lookup'.So let me know what it is doing exactly.

Thanks & Regards

Jai

Use of LOOKUP function

Tue, 08 Jun 2010 08:28:10 GMT

Using the lookup function is very bad for your reload perfomance. You better use a join or use the applymap function.

Use of LOOKUP function

Tue, 08 Jun 2010 08:37:36 GMT

Hi,

Thanks for ur kind reply.

Thanks & regards

Jai

Use of LOOKUP function

Tue, 08 Jun 2010 11:00:27 GMT

Hi Jai

I used it to look up text for the selected language.

=fieldvalue('$(vLang)',fieldindex('Lookup','Daily'))

The lookup by name makes it easier to see what text should be shown, so the lookup will provide the index to get the fieldvalue for the selected language.
$(vLang) is set to e.g. DE, EN, FR and the "Daily" record has the translations for each of the languages.

Regards

Jürg