Getselected value issue?

[#1]

Hi,

I have a field like this

field1( country@state@city)

IND@MP@CITY1
IND@AP@CITY2

IND@TG@CITY3

IND@UP@CITY4

i am using this field in list box with show tree view with '@'

so if a user select ind i want to show ind

if a user select state i want show state

if a user select city i want to show city

i want to show it in text object. i tried =getselectedfield(field1) but it is not giving the proper result.is it fisable in qlikview or not?

[datanibbler]

Hi rakesh,

try Getfieldselections() instead.

[Gabriel]

Hi,

Please attached sample file

[#4]

i dnt have sample file.

i have the scenario like this.i tried getfieldselections() also it's not working for me

[Anonymous]

so where you are trying if you dont have sample .. Just change your data and attached the app so that everybody can understand ur problem and can help.

Thanks

BKC

[#6]

Plz find the attachment.

If i click on city i want to show only city

here it is showing ind@ap@city1 like that

[Gabriel]

Hi,

Try this

=Subfield(Source,'@',3)  in a text box

And this will give you just city

=PurgeChar(Subfield(Source,'@',3),Right(Source,1))

[jonathandienst]

Use this expression in the text box:

=Subfield(Source, '@', -1)

or

=Concat(Subfield(Source, '@', -1), ', ')

if you want to display multiple selections

HTH

Jonathan

[#9]

thanks for ur reply

If a user select ind i want to show in text box as ind

if a user select ap i want to show as ap

if a user slect city i want to show as city

[Gabriel]

Just expand on my suggestion above using nested IF statement to check what's been selected