Use of LOOKUP function

[#1]

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

[#2]

Hi

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

Regards

Jürg

[#3]

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

[#4]

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

[#5]

Hi,

Thanks for ur kind reply.

Thanks & regards

Jai

[#6]

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