topic Text Object properties in QlikView

Text Object properties

Thu, 18 Jul 2013 22:22:41 GMT

Hi,

Please help me with text object properties. I want to display the below text using text object to show my conditional formatting criteria to the user.

Red≤ ASPIRE

Yellow< 5% above ASPIRE

Green≥ 5% above ASPIRE

Showing the above text is easy but instead of just writing what Red, Yellow and Green color indicates I want to show the color itself, something like this. If not exactly this, but still some color itself. May be coloring the text itself.

Please help me.

Thanks,

Shikha

Re: Text Object properties

swuehl — Thu, 18 Jul 2013 23:07:43 GMT

Use calculated color for the background of your text object

=if( VALUE >= 1.05* ASPIRE, green(),

if( VALUE > ASPRIE, yellow(), red()

))

Re: Text Object properties

rwunderlich — Fri, 19 Jul 2013 00:35:13 GMT

A simple way to create a colored legend box like this is a dimensionless straight table, with the "Horizontal' checked on the Presentation tab. Create an expression for each line of text and set the color in the expression background property.

See attached.

-Rob

http://masterssummit.com

http://robwunderlich.com