Qlik Community

Community Corner

Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

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
Specialist
Specialist

Try this in

If(Isnull(Fieldname),Red())

View solution in original post

8 Replies
IamBack
Champion
Champion

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
Specialist
Specialist

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

settu_periasamy
Master III
Master III
Author

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?

IamBack
Champion
Champion

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
Specialist
Specialist

Try this in

If(Isnull(Fieldname),Red())

settu_periasamy
Master III
Master III
Author

Thank you. This works.

datanibbler
Champion
Champion

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
Master III
Master III

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