topic Indicators Formatting in QlikView

Indicators Formatting

pgalvezt — Mon, 07 Feb 2011 14:49:18 GMT

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

Indicators Formatting

pgalvezt — Mon, 07 Feb 2011 21:55:37 GMT

Anyone?

Indicators Formatting

hector — Mon, 07 Feb 2011 22:24:56 GMT

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

Indicators Formatting

pgalvezt — Tue, 08 Feb 2011 13:01:56 GMT

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

Indicators Formatting

pgalvezt — Wed, 09 Feb 2011 13:08:01 GMT

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

Indicators Formatting

pgalvezt — Wed, 09 Feb 2011 14:19:59 GMT

Anyone?

Re: Indicators Formatting

Fri, 17 Aug 2012 12:27:10 GMT

Shouldn't there be a ")" here:

Aprovador_Remessa) > 0.99

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

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.