topic Re: Conditional Coloring of Text in a Text Box. (make negatives red) in QlikView

Conditional Coloring of Text in a Text Box. (make negatives red)

Thu, 14 May 2015 00:43:15 GMT

Text Box Display Formula: Expression using the contents of two other text boxes

Font Color Formula: IF (Expression > 0, green, red)

I use this method in my dashboard but it means that the entire expression has to be copied into the Font Color formula. The issues I have with this are:

1) Doesn't this affect performance because the formula has to be calculated twice? Once for the expression to be displayed in the text box and once for the text color?

2) Is there a way of referring to other calculations in other text boxes like you can in a Table Box. I have found that changes have been made to the expression that displays but those changes were not put into the color formula also. It would be nice if there was a "Current Expression Value" function or the ability to refer to another object like you can with a column. ie. if [Budget] - [Sales] >0, green, red. That way any changes in the Budget calculation would then be seen by the font color expression. Any ideas?

Re: Conditional Coloring of Text in a Text Box. (make negatives red)

danieloberbilli — Thu, 14 May 2015 01:01:18 GMT

You could write the expression once in a variable e.g.

vVar = sum(sales)

if($(vVar)>0,green(), red())

Re: Conditional Coloring of Text in a Text Box. (make negatives red)

Anonymous — Thu, 14 May 2015 01:05:04 GMT

1. Expression results are cached. That means if two expressions are exactly the same, they are calculated once, not twice. But if they are even a little different (sum in one but Sum in another) - each will be calculated.

2. Not exactly - but think of keeping expressions in variables. So, the variable eBudget contains expression for Budget calculations, and variable eSales - for Sales calculations.

Hope this will help you.

Re: Conditional Coloring of Text in a Text Box. (make negatives red)

krishna20 — Thu, 14 May 2015 07:00:56 GMT

Hi,

Try the below one

Re: Negative numbers in red / positive numbers in green in a text box