Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How to display a search string in a text object

I'm trying to figure out how I can display search strings after submitting them. For example, once I type a search string into a search object and press Enter, I would like to somehow display the string that was searched (possibly through a text object). Right now, the closes I can get is using GetFieldSelections() but it only shows a number (e.g. "324 of 13250") rather than the actual search string. I'm trying to get this to work for multiple search terms too. So if someone searches "test" the presses Enter, and searches "blue" and presses Enter, I want a text object to display "test, blue". Thank you in advance for your help!!

6 Replies
el_aprendiz111
Valued Contributor

Re: How to display a search string in a text object

Hi,

1 example

=Concat(DISTINCt Country,', ')

Re: How to display a search string in a text object

You can also use GetFieldSelections (https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/FieldFunctions/ge...) with the third parameter here:

Capture.PNG

GetFieldSelections(FieldName, ', ', 15000)

Not applicable

Re: How to display a search string in a text object

Thanks for the quick reply. Unfortunately, this only shows the matching field text. Instead, I'm trying to display the search text. For example, if I search for the word "bicycle," I want to output "bicycle" and not the field text that contains the search word.

Not applicable

Re: How to display a search string in a text object

I'm not getting this to work. It is still only displaying "# of #" rather than the actual search string.

vinieme12
Esteemed Contributor II

Re: How to display a search string in a text object

I don't think you can capture string from a search object

You can only capture Active Selections

beck_bakytbek
Honored Contributor

Re: How to display a search string in a text object

Hi Mehdi,

check this topic: https://www.youtube.com/watch?v=rIsbfthlTE4

i hope that resolves your issue

beck