select Domestic & International

[inam]

Hello Community 

i have excel code

=IFERROR(VLOOKUP(CE2,Sheet54!$J$2:$K$59,2,FALSE),"") 

I want to convert this Excel  formula in Qlikview.

here CE2 is  H Final

Expected output:-

V

Dom

INT

CE2 Data:-

H Final

Asia

Kerala

Europe

Maldives

Punjab

Andaman

Africa

[MayilVahanan]

Hi

Try with Mapping concept to achieve the result. 

Mapping | QlikView Help

[Lisa_P]

I think you are looking for the mapping table which is similar to a VLOOKUP.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes... 

[inam]

can you please help me how i map this ?

i try many times but not getting answer.

[inam]

can you please help me how i map this ?

i try many times but not getting answer.

sheet54 is Different table i map this table but getting error 

[Lisa_P]

Load table to lookup using Mapping prefix before load/select statement.

eg
NatInt_Map:
Mapping load Country, V from ....;

After loading the mapping table in the script use the Applymap function when you load the destination table to lookup the first field in the mapping table.

eg Load ...,
   [H  Final],
   Applymap('NatInt_Map', [H Final]) as NatInt,

...;