Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
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

13 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Unfortunately No

Not applicable
Author

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
Author

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

Not applicable
Author

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
Author

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
Specialist II
Specialist II

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
Partner - Specialist II
Partner - Specialist II

Hi Deepak,

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

Not applicable
Author

I use 11.2 SR3. Its there.

Which SR do you use. HighlightSearchSubstring.JPG

Not applicable
Author

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.