Conditional Formatting on Text Boxes

[#1]

I am trying to create a text box in Qlik Sense who's text is dependant on an equation.

For example, if the number of sales is above 1000 (i.e. SUM(Sales) > 1000) then I want the text box to say "Above Target" and if it is below 1000 then I want it to say "Below Target". Then expression will most likely be IF( SUM(Sales) > 1000, "Above Target", "Below Target") however I don't know where to add this expression. Is there somewhere in the Text & Image Chart settings panel that will allow me to do this, or do I need another chart all together?

Thanks.

[arthur_dom · Accepted solution]

Add as a measure.

Steps:

1. Drag and drop the txt/image object

2. click on it and on the right pane press + add measure

3. type " =IF( SUM(Sales) > 1000, 'Above Target', 'Below Target')  "

Notes:

On Qlik string text is passed on single quotes.