topic Re: Same column two dimension are there one dimension one colour and another dimension another color in App Development

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

lakshman1031 — Wed, 05 Mar 2025 08:44:40 GMT

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.

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

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

JandreKillianRIC — Wed, 05 Mar 2025 08:51:20 GMT

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

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

henrikalmen — Wed, 05 Mar 2025 10:06:11 GMT

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.)

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

diegozecchini — Wed, 05 Mar 2025 10:43:28 GMT

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"