topic Re: Visual Cue for a Text Object in QlikView https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392252#M423146 <HTML><HEAD></HEAD><BODY><P>This is my expression:</P><P>=IF(NUM(SUM(transQUANTITY),'#,###.')-num(sum(projectedSales+projCOMP),'#,###.') &gt;0, Green(), Red())</P><P></P><P>When I try to enter your equation, I get an output of RGB(128,0,0)</P></BODY></HTML> Thu, 21 Sep 2017 17:13:27 GMT evansabres 2017-09-21T17:13:27Z Visual Cue for a Text Object https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392250#M423144 <HTML><HEAD></HEAD><BODY><P>Is it possible to have a text object (with a numerical value) have a visual cue? For example, if the number is less than 0 be red, greater than 0 be green. I know how to do this in a chart, but wondering if it is possible in a text object?</P></BODY></HTML> Thu, 21 Sep 2017 17:06:06 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392250#M423144 evansabres 2017-09-21T17:06:06Z Re: Visual Cue for a Text Object https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392251#M423145 <HTML><HEAD></HEAD><BODY><P>You should be able to do this...</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177350_Capture.PNG" style="height: 248px; width: 620px;" /></P></BODY></HTML> Thu, 21 Sep 2017 17:09:37 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392251#M423145 sunny_talwar 2017-09-21T17:09:37Z Re: Visual Cue for a Text Object https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392252#M423146 <HTML><HEAD></HEAD><BODY><P>This is my expression:</P><P>=IF(NUM(SUM(transQUANTITY),'#,###.')-num(sum(projectedSales+projCOMP),'#,###.') &gt;0, Green(), Red())</P><P></P><P>When I try to enter your equation, I get an output of RGB(128,0,0)</P></BODY></HTML> Thu, 21 Sep 2017 17:13:27 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392252#M423146 evansabres 2017-09-21T17:13:27Z Re: Visual Cue for a Text Object https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392253#M423147 <HTML><HEAD></HEAD><BODY><P>I see where I made a mistake. This works, thank you.</P></BODY></HTML> Thu, 21 Sep 2017 17:15:19 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392253#M423147 evansabres 2017-09-21T17:15:19Z Re: Visual Cue for a Text Object https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392254#M423148 <HTML><HEAD></HEAD><BODY><P>What value does this give you in a text box object?</P><P></P><P><STRONG>Sum(TransQUANTITY) - Sum(projectedSales + projCOMP)</STRONG></P></BODY></HTML> Thu, 21 Sep 2017 17:16:07 GMT https://community.qlik.com/t5/QlikView/Visual-Cue-for-a-Text-Object/m-p/1392254#M423148 sunny_talwar 2017-09-21T17:16:07Z