topic Re: Problem with current selection box in QlikView

Problem with current selection box

Anonymous — Tue, 27 Mar 2018 10:19:31 GMT

Hi,

I Have a requirement where i have to use action->to select field->and in place of search string i have to use a variable.

This works fine as expected ! but the values in current selection box is showing as below.

("india"|"usa"|"uk")

instead of showing india,usa,uk

Attaching a sample application,can someone please provide me the solution to this problem.

Thanks,

Sandeep

Re: Problem with current selection box

chinnuchinni — Tue, 27 Mar 2018 10:39:58 GMT

just modify your your variable value as :

=GetFieldSelections(Country)

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 10:55:53 GMT

Hi Praveen,

Thanks for the replay.

In real, i have field values with spaces your solution is only working without spaces .

Please look into the new attached file.

Thanks,

Sandeep

Re: Problem with current selection box

chinnuchinni — Tue, 27 Mar 2018 11:07:43 GMT

you can use in script.

trim(Country) as Country

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 11:20:31 GMT

this does not solve my problem,

1)i cant trim the field values

2)search string in actions is not working if there are spaces in field values that is why i have used the below expression

='('&chr(34)& GetFieldSelections(Country,chr(34)&'|'&chr(34) ) &chr(34)&')'

Thanks

Re: Problem with current selection box

tresB — Tue, 27 Mar 2018 11:30:07 GMT

Try with chr(39), instead of chr(34)

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 11:37:21 GMT

Id	Country	len(Country)
		0
1	India	5
2	USA	3
3	UK	2
4	Australia	9
5	Brazil	6

I still do not understand your need, but in the field Country no have spaces...

The idea of Praveen is very good, solve in the script!

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 12:45:23 GMT

tried with 39 its not working

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 12:55:57 GMT

Hi Guy,

thanks for helping out.

Let me put it in a simple way,i need a button by clicking it USA new,UK new and India new should be selected in country field

and current selection box should show USA new,UK new,India new

insted of ("USA new","UK new","india new").

Thanks

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 12:57:04 GMT

Hi Guy,

thanks for helping out.

Let me put it in a simple way,i need a button by clicking it USA new,UK new and India new should be selected in country field

and current selection box should show USA new,UK new,India new

insted of ("USA new","UK new","india new").

Re: Problem with current selection box

Anonymous — Tue, 27 Mar 2018 13:14:21 GMT

Maybe this...

=Concat(Country,'|')

Re: Problem with current selection box

boorgura — Tue, 27 Mar 2018 15:03:10 GMT

You can use a macro for the selections:

sub selectField

ActiveDocument.Fields("Country").Select "UK new"

ActiveDocument.Fields("Country").Toggleselect "USA new"

end sub

Re: Problem with current selection box

tresB — Wed, 28 Mar 2018 05:09:47 GMT

You could try using multiple toggle select actions as an alternative. PFA

Re: Problem with current selection box

jonathandienst — Wed, 28 Mar 2018 06:21:49 GMT

If you create a bookmark and then use Replace Bookmark / Apply Bookmark actions, the search syntax is not required and the search box will simply show the selected items in the way you want: