Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Indicators Formatting

Hi everyone, I've created a text object with this formula, but it doesn't work. The idea is, when the indicators is greater than cero = green, if not red. Thanks for your help.

=

if(count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},[Processo Dias]={'Até 1 Hora'},Status_Remessa={'APR'}>}Aprovador_Remessa))/Count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},Status_Remessa={'APR'}>}Aprovador_Remessa > 0.99, RGB(255 ,0, 0),RGB(0 ,128, 0))



6 Replies
pgalvezt
Specialist
Specialist
Author

Anyone?

hector
Specialist
Specialist

Hi

sorry, but i'm not following at all....

Some questions:

  • Is this the expression on a chart with type Indicator?
  • or is this the expression of a text object and you want to change the bkg color??

Rgds

pgalvezt
Specialist
Specialist
Author

Thank you for your reply:

  • this is the expression of a text object and upper 0.99 I want to put in yellow, lower in red, and 100% in green.

Thnks...

pgalvezt
Specialist
Specialist
Author

or maybe put the numbers with color. The idea is change the color of the numbers or inside of the text object.

pgalvezt
Specialist
Specialist
Author

Anyone?

Not applicable

Shouldn't there be a ")" here:

Aprovador_Remessa) > 0.99

Otherwise the second Count() expression doesnt end until the first ")" is encountered.

So

=

if(count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},[Processo Dias]={'Até 1 Hora'},Status_Remessa={'APR'}>}Aprovador_Remessa))/Count({<Aprovador_Remessa={'Célula de Ativo Fixo'},Emergencial_Remessa={'1 Hora'},AprovadorNivelRemessa={'Célula de Ativo Fixo-20'},Status_Remessa={'APR'}>}Aprovador_Remessa) > 0.99, RGB(255 ,0, 0),RGB(0 ,128, 0))

If this is the expression in the text box, then the answer here iseither RGB(255 ,0, 0) or RGB(0 ,128, 0). So not the colour, but that text.

To use this, you need to past the expression in the Font tab under the Color button and then in the Calculated Base color field.