topic Re: Highlighting substring in QlikView

Highlighting substring

Fri, 21 Mar 2014 07:53:09 GMT

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

Re: Highlighting substring

alexandros17 — Fri, 21 Mar 2014 07:54:55 GMT

Unfortunately No

Re: Highlighting substring

Fri, 21 Mar 2014 08:00:26 GMT

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.

Re: Highlighting substring

Fri, 21 Mar 2014 08:08:22 GMT

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

Re: Highlighting substring

Fri, 21 Mar 2014 08:15:18 GMT

Hi Ramdas,

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

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!

Re: Highlighting substring

Fri, 21 Mar 2014 09:16:37 GMT

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'

Re: Highlighting substring

ThornOfCrowns — Fri, 21 Mar 2014 09:21:09 GMT

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-extension/ which may give you some hope.

Re: Highlighting substring

manojkulkarni — Fri, 21 Mar 2014 09:21:17 GMT

Hi Deepak,

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

Re: Highlighting substring

Fri, 21 Mar 2014 09:46:09 GMT

I use 11.2 SR3. Its there.

Which SR do you use.

Re: Highlighting substring

Fri, 21 Mar 2014 10:17:07 GMT

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.

Re: Highlighting substring

Fri, 21 Mar 2014 10:20:55 GMT

Thank you guys trying to help me out but i think there is no solution available to the particular scenario .....

Re: Highlighting substring

Fri, 21 Mar 2014 13:07:00 GMT

Depends which version are you using.. I use 11.2 SR3. we have a direct option to do that using a checkbox.

Re: Highlighting substring

Mon, 24 Mar 2014 05:45:30 GMT

Thank you James for the hint. I do come up with a post (the solution) if i get exactly what i wanted.

Re: Highlighting substring

vsabbise — Fri, 30 Nov 2018 23:33:23 GMT

May I know how to add color instead of Upper ?