topic Re: Substring Issu in QlikView

Substring Issu

vanderson009 — Wed, 23 Apr 2014 05:05:57 GMT

Hello Community,

I have substring in my text as "Hello World"

and i want that Hello Word become in Red color.

- Thanks and Regards,

Villyee.

Re: Substring Issu

CELAMBARASAN — Wed, 23 Apr 2014 05:13:26 GMT

There is no functions/ features to highlight certain region of the text.

In which object you need this kind of feature?

If it's a text object, then you could try with Qlikview extension objects. Check the below link for more information

QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension)

Re: Substring Issu

CELAMBARASAN — Wed, 23 Apr 2014 05:14:16 GMT

There is no functions/ features to highlight certain region of the text.

In which object you need this kind of feature?

If it's a text object, then you could try with Qlikview extension objects.

Re: Substring Issu

its_anandrjs — Wed, 23 Apr 2014 05:14:58 GMT

It is in database or in any row you ask. If it is in text object then use font option and color option.

Re: Substring Issu

vanderson009 — Wed, 23 Apr 2014 05:17:02 GMT

Yes It is Database Column.

Re: Substring Issu

vanderson009 — Wed, 23 Apr 2014 05:33:56 GMT

You have any QlikView Extension sample related to that,

and its not text it database column, so how could i handle it in QlikView Extension.

- Thanks and Regards,

Villyee

Re: Substring Issu

CELAMBARASAN — Wed, 23 Apr 2014 05:50:11 GMT

I posted a link but it needs moderator approval itseems.

"qliktip-39-displaying-html-content-minimalistic-htmltextbox-object-extension"

Search this text in google and it points to qlikblog .at url

Re: Substring Issu

sundarakumar — Wed, 23 Apr 2014 06:45:35 GMT

I think there is no fuction to change the color of a particular sub string. the font color bing set is universal for the entire text. If want it to work that way, u can keep them in different text boxes....

say i have

"Hi this is the sataement. Hello World!!!"

if u want only "Hello World" to be in red, then u should put

"Hi this is the sataement." in a seperate text box with font color black

and then

"Hello World" in seperate text box with font color red...

pls note this doesnot work when u have dynamic text strings. bec u cannot move the position of the second text box dynamically.

-Sundar