How to use Condition lise if elseif else endif or Select Case - 1, case -2 , case 3 end

[#1]

Hi

Can someone answer me how do I use condition in EXPRESSION section

like

Table Name: Customer

Filed Name=Country

Country exist data like 'US', 'UK', 'JAPAN', 'INDIA'

if sysdba.Customer.Country='US' then 'New York'

elseif sysdba.Customer.Country='UK' then 'London'

else if sysdba.Customer.Country='Japan' Then 'Tokyo'

else 'Delhi'

endif

or same formula in SQL 2000

Case when sysdba.Customer.Country='US' then 'New York'

when sysdba.Customer.Country='UK' then 'London'

when sysdba.Customer.Country='Japan' then 'Tokyo'

else 'Delhi'

end

[#2 · Accepted solution]

Hope the following article would help you (bu using mapping)

http://www.qlikblog.at/546/qliktip-20-selectcase-qlikview-loadscripts/