Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with current selection box

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

13 Replies
Anonymous
Not applicable
Author

Maybe this...

=Concat(Country,'|')

boorgura
Specialist
Specialist

You can use a macro for the selections:

sub selectField

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

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

end sub

tresesco
MVP
MVP

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

jonathandienst
Partner - Champion III
Partner - Champion III

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:

Capture.PNG

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein