topic Re: To get the Country from an Address in QlikView

To get the Country from an Address

Fri, 20 Nov 2020 18:02:30 GMT

Hello Everyone,

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

Cheers.-

Mirco

Re: To get the Country from an Address

datanibbler — Wed, 09 Jul 2014 09:43:14 GMT

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.

Re: To get the Country from an Address

Siva_Sankar — Wed, 09 Jul 2014 09:46:39 GMT

Hi,

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

SubField() Function in QlikView Application: Part 1

Regards,

siva