Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
Anonymous
Not applicable

Try this in

If(Isnull(Fieldname),Red())

View solution in original post

8 Replies
SunilChauhan
Champion II
Champion II

expand + sign before dimension

select test color and type there you color code

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

hope this helps

Sunil Chauhan
Anonymous
Not applicable

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?

SunilChauhan
Champion II
Champion II

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

Sunil Chauhan
Anonymous
Not applicable

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