Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is there a way to Highlight or Change the color of a sub string in the whole text ? . I am using a variable to input a substring and displaying the whole text in a text box. I can use Upper(variable name) but looking for something similar to blue(variable name).
I have this:
(if(SubStringCount((wholetext),vWord1)>0,Replace(wholetext,vWord1,upper(vWord1))))
I want this:
(if(SubStringCount((wholetext),vWord1)>0,Replace(wholetext,vWord1,Blue(vWord1))))
This it enough, I hope
if(SubStringCount((wholetext),vWord1)>0, Blue())
I can explain what I am asking for again. Lets say my wholetext = "Qlik sense is a useful tool from Sweden".
I have my variable input box entered as useful.
I need my text box to have the text with useful in blue color "Qlik Sense is a useful tool from Sweden"
I am using input box using qsvariable extension and expression in the text box.
All I need is how to change a string color using expression in Qlik Sense text box expression.
Again saying that, If i understand the question correctly. Answer is NO. That means, If you have string called "Welcome to Qlik" in that you want to use?
If(SubStringCount('Welcome to Qlik',vWord1)>0, Blue()) // where vWord1 is Qlik. You want to make that in high light color? Like this.
Your output should be this in Qlik KPI? If so, I suggest to use
Welcome to Qlik