Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Object properties

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.

table.jpg

Please help me.

Thanks,

Shikha

2 Replies
swuehl
MVP
MVP

Use calculated color for the background of your text object

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

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

     ))

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

Capture.PNG

See attached.

-Rob

http://masterssummit.com

http://robwunderlich.com