Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums

change the text color in dimension

Hi Guys,

I have to change the text color  in  the dimension value. like the below screen shot.

I need to change the text color (Only Not Assigned) should be red. First two columns are in dimension, third one is expression.

qv_sample.PNG.png

Thanks in Advance.

regards,

sethu

1 Solution

Accepted Solutions
jebamalai
Valued Contributor

Re: change the text color in dimension

Try this in

If(Isnull(Fieldname),Red())

8 Replies
SunilChauhan
Esteemed Contributor

Re: change the text color in dimension

expand + sign before dimension

select test color and type there you color code

for Ex RGb(180,180,180) for gray

hope this helps

jebamalai
Valued Contributor

Re: change the text color in dimension

Go to Dimensions->Click the + Symbol->Text Color->Edit->If(Field='Not Assigned',Red())

Re: change the text color in dimension

Thank you. But, if  i mentioned the Null Symbol and Missing Symbol as Not Assigned in the presentation tab, i'm not able to change the color in the table. see the below screen shot.123.jpg

can you help on this?

SunilChauhan
Esteemed Contributor

Re: change the text color in dimension

in  text color of dimension

you can write like below

if(fieldname='Not Assigned' , Red(),Green())

take your fieldname in place of fieldname
and write in both fields

hope this helps

jebamalai
Valued Contributor

Re: change the text color in dimension

Try this in

If(Isnull(Fieldname),Red())

Re: change the text color in dimension

Thank you. This works.

datanibbler
Esteemed Contributor

Re: change the text color in dimension

Hi,

I have not really tried this out before - but I would guess you are right, Jebamalai. That 'Not assigned' is seemingly only a text which sethu has entered in the dialog (to be displayed), it is not the value that is actually in the field?

<=> You would probably have to make the colour dependent on the actual value, not the value that is to be displayed - alternatively you could assign this on scripting level.

Best regards,

DataNibbler

anbu1984
Honored Contributor III

Re: change the text color in dimension

If(Field Is Null Or Field='Not Assigned',Red())

Community Browser