Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
bnelson111
Creator
Creator

Change Expression Text Color Based on Value.

Everyone,

I have an interesting challenge which maybe simple but has be beaten. Aim is to change the color of the number based on the value from the expression which is in a Text Box.

Expression below:

', Slit Mtrs '&(num(sum({<

PSADATA.processtype={"*slt*"},

PSADATA.Description={"*ASH*"}>} PSADATA.quantity)  ,'#,##0'))

Basically if above value comes back over 2000 then I wish it to be displayed in RED. So below 119,177 should be red not black and below is a text box made with expressions.

www.png

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

May be Based on Calculated Condition Font Color Based on Condition?

Check the Attachment.

Capture.JPG

View solution in original post

5 Replies
sinanozdemir
Specialist III
Specialist III

I don't think you can change the color of a partial text in a text box. Although, you can layer another text box just for the numbers and change the color of that text box.

roger_stone
Creator III
Creator III

Use two text boxes and make each conditional on the value.

As Sinan says, you can't change part of the colour in a text box.

ganeshreddy
Creator III
Creator III

settu_periasamy
Master III
Master III

Hi,

May be Based on Calculated Condition Font Color Based on Condition?

Check the Attachment.

Capture.JPG

View solution in original post

bnelson111
Creator
Creator
Author

Thanks.