topic Re: Change Expression Text Color Based on Value. in QlikView

Change Expression Text Color Based on Value.

bnelson111 — Thu, 03 Dec 2015 13:32:07 GMT

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.

Re: Change Expression Text Color Based on Value.

sinanozdemir — Thu, 03 Dec 2015 13:35:37 GMT

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.

Re: Change Expression Text Color Based on Value.

roger_stone — Thu, 03 Dec 2015 13:42:01 GMT

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.

Re: Change Expression Text Color Based on Value.

ganeshreddy — Thu, 03 Dec 2015 13:51:50 GMT

This may helps you.

TExt BOx Value Color change

Change Expression Text Color Based on Value.

Regards,

Ganesh

Re: Change Expression Text Color Based on Value.

settu_periasamy — Thu, 03 Dec 2015 14:03:40 GMT

Hi,

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

Check the Attachment.

Re: Change Expression Text Color Based on Value.

bnelson111 — Thu, 03 Dec 2015 14:29:25 GMT

Thanks.