Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change color area on minichart

Hello

How can i change COLOR AREA of mini chart based on expression? My expression is like

=IF(($(TESTE_SINAL))<0, Green(), Red())

TESTE_SINAL can be between -1 and 1. But the color always return GREEN().

Sds

5 Replies
Not applicable
Author

Hello,

please try,

=IF(($(TESTE_SINAL))<0, Green(), IF(($(TESTE_SINAL)>0,Red())

nested IF, you can use any number of them according to the requirement.

Hope this helps.

Mady

Not applicable
Author

Hello,

I appreciated your help, but don´t work yet...

:-((

Sds

Not applicable
Author

have you tried this?

=IF(($(TESTE_SINAL))<'0', Green(), Red())

Not applicable
Author

Yes, i tried it too..

And i created a variable like

IF($(TESTE_SINAL)<0, Green(), IF($(TESTE_SINAL)>0,Red() ) ) l

and it return RGB(0,128,0)  or RGB(128,0,0).

Bun in Chart, only draw green color....

Not applicable
Author

I tried another way...

I used that variable create before as column on table and drow the color on cell backgroud, and works fine.

The problem is only mini chart bar...