topic Re: TExt BOx Value Color change in QlikView

TExt BOx Value Color change

abhaysingh — Sat, 09 May 2015 11:12:05 GMT

hi All,

i have target in one text box and in other actual, i want when my target > Actual it should show red color else green color

Re: TExt BOx Value Color change

Anonymous — Sat, 09 May 2015 11:26:05 GMT

On the Font tab of the Text Box :

<Click> Color
<Click> Calculated
Enter expression
- if ( target > Actual , Red(), Green() )

Re: TExt BOx Value Color change

sunny_talwar — Sat, 09 May 2015 11:32:54 GMT

It seems you have two text boxes? Do you want both turn Red or Green at the same time or Do you want only Target to turn Red when Target > Actual and only Actual to turn green when Actual > Target?

Re: TExt BOx Value Color change

sunny_talwar — Sat, 09 May 2015 11:40:04 GMT

If condition might change, but the procedure will remain the same as listed by Bill Markham‌. The same procedure looking at a image is as follows:

I hope this will help.

Best,

Sunny

Re: TExt BOx Value Color change

abhaysingh — Sat, 09 May 2015 11:51:18 GMT

yes i have two target i want actuals to turn red or green when target> actual

Re: TExt BOx Value Color change

sunny_talwar — Sat, 09 May 2015 12:00:30 GMT

Have a look at the attached document. It is green when nothing is selected because Sum(Actual) > Sum(Target)

But as soon as you select A, the text box turns Red:

See the steps I used:

I hope this will clarify you the process.

Best,

Sunny