topic Re: Text color script in QlikView

Text color script

Mon, 28 Jul 2014 08:58:38 GMT

Hello everyone,

I wonder if there is any way of defining the color of a text string directly on the script or via a calculated expression.

It is not useful to me to change the color on the properties of the dimension.

What I was aiming for was to define one dimension like this:

=black(field1) & white(field2)

I know this is not the correct syntax, but I believe this is possible. Via script or via calculated dimension.

Can anyone help?

Thank you!!!

Best regards!

Re: Text color script

PradeepReddy — Mon, 28 Jul 2014 09:16:00 GMT

I think it is not possible to highlight the text as u r looking...

We can change the color of entire text using the the calculated expression from "Font" tab of the text object..

Font-->Calculated Dimension (Write the expression here)

Re: Text color script

Mon, 28 Jul 2014 11:37:35 GMT

You could add the color of each field as another field on the data source. After you load it into QlikView, you can access that information on the different objects.

For example:

The color format should be something like this RGB(255, 232, 0)

RGB recieves the values of red, green and blue of each color.

Hope it helps

Re: Text color script

aveeeeeee7en — Mon, 28 Jul 2014 11:44:03 GMT

Hi Ivo

You can use Custom Format Cells Option. See the Snapshot:

Regards

Aviral Nag

Re: Text color script

aveeeeeee7en — Mon, 28 Jul 2014 11:48:47 GMT

For Custom Format Cell do the following Setting:

1. Ctrl+Shift+U or Simply Go to Settings > User Preferences and then move to Design Tab > Check the Option "Always Show design Menu Items" > The Chart on which you have to make the Colored rows > Right Click on it > There you see the Option Custom Format Cells > From there you can change colors, format, etc.