topic Get field value in QlikView

Get field value

eliran — Mon, 15 Aug 2011 12:59:24 GMT

Hi all,

A quick question for you, I have a table of countries and one of the attributes is Region Code.

When the user selects a specific country, I would like to return the text from the region table (description).

I didn't bump in a function that receiving field value, a function like this would help in this case.

I'll appreciate any help.

Regards,

Eliran

swuehl — Mon, 15 Aug 2011 13:05:02 GMT

Hi,

is it not possible to link the two tables with common field name (maybe Region Code)?

Table Country:

Country, RegionCode

USA, 1

Table Region:

RegionCode, Desc

1, North America

lironbaram — Mon, 15 Aug 2011 13:08:29 GMT

hei

assuming there is only one value after you selected the country

you can write this expression in the text box

=only(region Description) that way when you wo'nt select a country it won't show anything

if there is more than one value you can use

=concat(region Description,',') that way it will show all the possible values in the field sperated by comma

hop its help you

eliran — Mon, 15 Aug 2011 13:13:15 GMT

Hi Liron,

I knew it was something easy..

Only was what I was looking for.

swuehl, they are connected of course, I just forgot how to take out the string according to selection.

Thanks.

Thanks!

Eliran.