Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Change color area on minichart

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

Change color area on minichart

Hello,

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

:-((

Sds

Not applicable

Change color area on minichart

have you tried this?

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

Not applicable

Change color area on minichart

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

Change color area on minichart

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...