Qlik Community

Qlik Community Help Discussions

Discussion board for questions on how to use Qlik Community and its features.

Not applicable

Highlighting substring

Hi,

I wanted to know is it possible to select a sub string of text and highlight it with color.
for example when we will give a search in a listbox, particular string will be highlighted automatically.

Thanks in advance,

Ramdas Hegde

12 Replies

Re: Highlighting substring

Unfortunately No

Not applicable

Re: Highlighting substring

Actually i have tried to highlight the substring using following expression (if(SubStringCount((text),Variable5)>0,Replace(text,Variable5,upper(Variable5))))
in this variable contains the substring

Here actually i wnted to highlight the text by color instead of using upper.

Not applicable

Re: Highlighting substring

Yes It can be done... You have to go  to the Presentation tab and check the "Highlight Search Substring" Checkbox.

Not applicable

Re: Highlighting substring

Hi Ramdas,

Have you tried the below option (I am assuming you are using a Search Box):

search_111453.bmp

Right click on the Search box, go to properties--presentation tab, in Search Result section, you can click on "Highlight Search Substring" option.
Hope this helps!

Not applicable

Re: Highlighting substring

Actually i am not using search box, i am using list box
example situation is that i am having list of words and i am having list of sentences.
I have created variable called Variable5 and i am trying to highlight the particular word in the text.
so i used the following expression in listbox 

     Replace(text,Variable5,upper(Variable5))

replacing the particular word by uppercase letters

if word is: 'helpful'
text is: 'this solution is helpful'

the expression will give: 'this solution is HELPFUL'

instead of it i want some what this :'this solution is helpful'

thornofcrowns
Valued Contributor II

Re: Highlighting substring

Until Qlikview adopts some form of markup, HTML / CSS etc., this isn't possible 'out of the box'. However, have a look at this: http://www.qlikblog.at/1579/qliktip-39-displaying-html-content-minimalistic-htmltextbox-object-exten... which may give you some hope.

manojkulkarni
Valued Contributor II

Re: Highlighting substring

Hi Deepak,

I don't see this option. I am using v11.2

Not applicable

Re: Highlighting substring

I use 11.2 SR3. Its there.

Which SR do you use. HighlightSearchSubstring.JPG

Not applicable

Re: Highlighting substring

As far as I know, unfortunately there is no such option available.

Alternativey, you can display just the variable vaue i.e. 'helpful' in this case, in a text object and give the desired color.

I know, this is not the exact requirement but just an option.