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?