Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Conditional Formatting on Text Boxes

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.

1 Solution

Accepted Solutions
arthur_dom
Contributor III

Re: Conditional Formatting on Text Boxes

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.

1 Reply
arthur_dom
Contributor III

Re: Conditional Formatting on Text Boxes

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.

Community Browser