topic Re: Getselected value issue? in QlikView

Getselected value issue?

Tue, 24 Mar 2015 12:39:33 GMT

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?

Re: Getselected value issue?

datanibbler — Tue, 24 Mar 2015 12:43:53 GMT

Hi rakesh,

try Getfieldselections() instead.

Re: Getselected value issue?

Gabriel — Tue, 24 Mar 2015 12:44:28 GMT

Hi,

Please attached sample file

Re: Getselected value issue?

Tue, 24 Mar 2015 12:46:16 GMT

i dnt have sample file.

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

Re: Getselected value issue?

Anonymous — Tue, 24 Mar 2015 12:49:11 GMT

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

Re: Getselected value issue?

Tue, 24 Mar 2015 13:43:42 GMT

Plz find the attachment.

If i click on city i want to show only city

here it is showing ind@ap@city1 like that

Re: Getselected value issue?

Gabriel — Tue, 24 Mar 2015 13:53:16 GMT

Hi,

Try this

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

And this will give you just city

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

Re: Getselected value issue?

jonathandienst — Tue, 24 Mar 2015 13:56:10 GMT

Use this expression in the text box:

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

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

if you want to display multiple selections

HTH

Jonathan

Re: Getselected value issue?

Tue, 24 Mar 2015 14:12:54 GMT

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

Re: Getselected value issue?

Gabriel — Tue, 24 Mar 2015 14:34:36 GMT

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

Re: Getselected value issue?

jonathandienst — Wed, 25 Mar 2015 05:45:22 GMT

With the hierarchy list box, you are selecting one or more a values of Source. It is not possible to select "ind' as such as it is not at the lowest level. To do what you require would require 3 fields (ie country, state, city) and 3 list boxes.

Jonathan

Re: Getselected value issue?

Wed, 25 Mar 2015 06:08:36 GMT

Thanks,i guess it is not possible using the hierarchy list box