Same column two dimension are there one dimension one colour and another dimension another color

[lakshman1031]

Hi Team,

I have table number of column are there, 

One column having Name & ID are concatenates,

Now I want display table Name Filed value shows red and Id values shows Blue.

Like 

Name&ID    Value   Range   Version 

A(Red) 1(Blue)   1    10     12

B(Red color)  2 (blue color)     2     15      12 

like that

How will do this one.

Thanks in advance.

Regards,

Ram

[JandreKillianRIC]

Hi @lakshman1031 

If this is in the same column / dimension this is not possible. 

The best option will be to split the Dimension into 2 separate fields and color them accordingly. 

Based on the text color, we can only assign one color based on a expression, Not split that into multiple's if that makes sense.

Regards Jandre 

[henrikalmen]

Another way of saying what @lakshman1031 already said is: you can't have two different text colours in one cell in a qlik sense table. (At least not standard tables, perhaps there are third party extensions that have other possibilities.)

[diegozecchini]

Hi!
To modify your data model you can use something like that

LOAD
SubField(Name_ID, ' ', 1) AS Name,
SubField(Name_ID, ' ', 2) AS ID,
Value,
Range,
Version
FROM YourDataSource;

Then in the viz, set color conditions "Text Color Expression"