topic Re: How to write multicolor texts/numbers in a Text Box in QlikView

How to write multicolor texts/numbers in a Text Box

Anonymous — Wed, 14 Sep 2016 23:48:02 GMT

Hi Friends, I have the below challenge:

The 3 Figures in the Text box below, I need to be green or red based on calculated condition using RGB Values. These figures will also be variables doing count/sum function. The text I need to be Black. Is it possible. The code I have for now is

=' Total Inventory: 28,000 Backlog: 45%' &chr(10)& 'Current Inventory: 12,000'

Thanks much.

Re: How to write multicolor texts/numbers in a Text Box

sunny_talwar — Wed, 14 Sep 2016 23:49:35 GMT

You will have to use multiple text boxes to get this done or an extension. Inbuilt capabilities doesn't allow for multiple formatting in a single text box object

Re: How to write multicolor texts/numbers in a Text Box

marcus_sommer — Thu, 15 Sep 2016 05:27:29 GMT

You could use an extension for this: Qlik Branch.

- Marcus

Re: How to write multicolor texts/numbers in a Text Box

Anonymous — Fri, 16 Sep 2016 02:02:28 GMT

Thanks Guys.

Re: How to write multicolor texts/numbers in a Text Box

Anil_Babu_Samineni — Fri, 16 Sep 2016 03:21:12 GMT

If your problem solved. Please close this thread using flag correct answer which is suitable for you

Try with word crump extension

Re: How to write multicolor texts/numbers in a Text Box

Anonymous — Fri, 16 Sep 2016 03:54:12 GMT

I chose Assumed Answered because that is the most accurate criteria. There was no exact & accurate answer but there were viable/ promising options available.