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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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