Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Is anyone know to say me how to get the country from an address field?
Cheers.-
Mirco
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.
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.
Hi,
Try using subfiled function. Follow the below url for step by step instructions.
SubField() Function in QlikView Application: Part 1
Regards,
siva