topic Re: Subfield function in QlikView

Subfield function

Wed, 15 Apr 2015 06:26:54 GMT

Hi All,

I am using a field called Domiciled Country where the values are as below.

I want to get inly the country name. i.e. Afghanistan

In this scenario how to use Sub field function.

Domiciled Country

803;#Afghanistan

824;#Bhutan

825;#Bolivia

what I want is as below.

Domiciled Country

Afghanistan

Bhutan

Bolivia

Please advise.

Thanks

Ashish

Re: Subfield function

PrashantSangle — Wed, 15 Apr 2015 06:30:32 GMT

Hi,

Try like

subfield(Domiciled,'#',2)

Regards

Re: Subfield function

pokassov — Wed, 15 Apr 2015 06:31:44 GMT

Hello!

May be more easy way is using function PurgeChar?

q1:

load

PurgeChar(Country,'0123456789;#') as CountryClear

Resident

Domiciled;

Re: Subfield function

tobias_klett — Wed, 15 Apr 2015 06:35:03 GMT

Hi,

try this:

subfield([Domiciled Country],';',1) as DomiciledCountryCode,

subfield([Domiciled Country],'#',2) as DomiciledCountry

Hope this helps

Tobias

Re: Subfield function

stigchel — Wed, 15 Apr 2015 06:36:19 GMT

Or try with SubField and alt function for when it's null in the first two cases, something like

Alt(subfield([Domiciled country],'#',2),[Domiciled country])

Re: Subfield function

Wed, 15 Apr 2015 06:38:48 GMT

Thanks Max for your quick response.

it's working as expected.

Re: Subfield function

raghvendrasingh — Wed, 15 Apr 2015 06:46:43 GMT

Hi,

Please try the below script:

Tab1:

LOAD * INLINE [

Country

Domiciled

Country

803;#Afganistan

824;#Bhutan

825;#Bolvia

];

NoConcatenate

Tab2:

Load purgechar(Country,'0123456789;#') as Country Resident Tab1;

Drop table Tab1;