To get the Country from an Address

[#1]

Hello Everyone,

Is anyone know to say me how to get the country from an address field?

Cheers.-

Mirco

[datanibbler · Accepted solution]

Hi Mirco,

if the address_field contains the country, you can simply cut it out using the "String functions" (in the help file) like LEFT, RIGHT, MID and SUBSTRING.

If it doesn't, then you need a mapping table with the adresses in one column and the country in a second one. Then you can use the Applymap() function.

[Siva_Sankar]

Hi,

Try using subfiled function. Follow the below url for step by step instructions.

SubField() Function in QlikView Application: Part 1

Regards,

siva