Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Unfortunately No
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.
Yes It can be done... You have to go to the Presentation tab and check the "Highlight Search Substring" Checkbox.
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!
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'
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.
Hi Deepak,
I don't see this option. I am using v11.2
I use 11.2 SR3. Its there.
Which SR do you use.
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.