Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

if statement to upload multiple country

Hi I have multiple countries which i want to upload in script in single format ,I have the script as follows  but i am not able to load it

if(RegistrationStoreLocation='INDIA',India',if(RegistrationStoreLocation='JAPAN','Japan',if(RegistrationStoreLocation='CHINA','China'))) as Country,

4 Replies
MVP
MVP

Re: if statement to upload multiple country

Why don't you try using Captialize() function, if all you want is to make 1st letter upper case and all other lower case

LOAD RegistrationStoreLocation,

          Capitalize(RegistrationStoreLocation) as Country

FROM ....

vinay_bangari
Valued Contributor III

Re: if statement to upload multiple country

stalwar1

i did not know of this function. Thank you

MVP
MVP

Re: if statement to upload multiple country

Ofcourse you do

vinay_bangari
Valued Contributor III

Re: if statement to upload multiple country

yaar sunny i really don't know man.

Community Browser