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

Thu, 07 Apr 2011 15:04:40 GMT

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

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

Thu, 07 Apr 2011 15:15:11 GMT

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

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