topic Change text object background color without duplication expression in QlikView https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142299#M890065 <HTML><HEAD></HEAD><BODY><P>Hi. I have a text object with a value that has a rather long formula. I hope to change the background color of the text box based on its value (e.g. red if below 0 and green otherwise). Right now I am just duplicating the formula into the color condition and it's working fine. But I am wonder if there's a more elegant way to do it rather than duplicating it? I thought of setting the value to a variable but couldn't seem to find an appropriate trigger.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Change text object background color without duplication expression https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142299#M890065 <HTML><HEAD></HEAD><BODY><P>Hi. I have a text object with a value that has a rather long formula. I hope to change the background color of the text box based on its value (e.g. red if below 0 and green otherwise). Right now I am just duplicating the formula into the color condition and it's working fine. But I am wonder if there's a more elegant way to do it rather than duplicating it? I thought of setting the value to a variable but couldn't seem to find an appropriate trigger.</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142299#M890065 2020-11-25T16:16:04Z Re: Change text object background color without duplication expression https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142300#M890067 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please see attached.</P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Mon, 05 Sep 2016 17:14:36 GMT https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142300#M890067 agomes1971 2016-09-05T17:14:36Z Re: Change text object background color without duplication expression https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142301#M890069 <HTML><HEAD></HEAD><BODY><P>Thanks. Works beautifully!</P></BODY></HTML> Tue, 06 Sep 2016 00:45:09 GMT https://community.qlik.com/t5/QlikView/Change-text-object-background-color-without-duplication/m-p/1142301#M890069 2016-09-06T00:45:09Z