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,
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.
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
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.
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.