https://community.qlik.com/t5/App-Development/Expresi%C3%B3n-de-colores-muy-extensa/m-p/2083333#M88807 <P>Buenas tardes,</P> <P>Necesito colorear las dimensiones de una tabla pivotante en función de unos límites. El problema que tengo es que tarda muchísimo en mostrar los datos y colores debido a los cálculos que tiene que hacer por la cantidad de dimensiones.</P> <P>Hay alguna otra forma de configurar la siguiente expresión que sea más ágil?</P> <P>:</P> <DIV>if(Indicador='PRODUCCION (Tm)' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV><SPAN> IF(Indicador='PRODUCCION (Tm)' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</SPAN></DIV> <DIV>&nbsp; &nbsp; IF(Indicador='PRODUCCION (Tm)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='Tm/TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV><SPAN> IF(Indicador='Tm/TOTAL EFECTIVOS' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</SPAN></DIV> <DIV>&nbsp; &nbsp; IF(Indicador='Tm/TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(Indicador='COSTE MANO DE OBRA (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='COSTE MANO DE OBRA (€/Kg)' AND ([acVar%. vs Presup.]&lt;=+0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='COSTE MANO DE OBRA (€/Kg)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='EFECTIVOS PROPIOS' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS PROPIOS' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS PROPIOS' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='EFECTIVOS ETT' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS ETT' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS ETT' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='TOTAL EFECTIVOS' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GASTO CEU (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='GASTO CEU (€/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='GASTO CEU (€/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND ([acVar%. vs Presup.]&lt;=+0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='MANTENIMIENTO(€)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MANTENIMIENTO(€)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MANTENIMIENTO(€)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO GAS (Kwh/kg))' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO GAS (Kwh/kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO GAS (Kwh/kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO MERCADONA (SERVIDO VS PEDIDO)' and (Real-Presupuesto)&gt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO MERCADONA (SERVIDO VS PEDIDO)' and (Real-Presupuesto)&lt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO OTROS CLIENTES (SERVIDO VS PEDIDO)' AND (Real-Presupuesto)&gt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO OTROS CLIENTES (SERVIDO VS PEDIDO)' AND (Real-Presupuesto)&lt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND [acVar%. vs Presup.]&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND if(IsNull((acReal-acPresupuesto)/acPresupuesto),'0',(acReal-acPresupuesto)/acPresupuesto)&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vAmarillo,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND [acVar%. vs Presup.]&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito</DIV> <DIV>)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))</DIV> Tue, 13 Jun 2023 15:08:24 GMT PepeOssa 2023-06-13T15:08:24Z https://community.qlik.com/t5/App-Development/Expresi%C3%B3n-de-colores-muy-extensa/m-p/2083333#M88807 <P>Buenas tardes,</P> <P>Necesito colorear las dimensiones de una tabla pivotante en función de unos límites. El problema que tengo es que tarda muchísimo en mostrar los datos y colores debido a los cálculos que tiene que hacer por la cantidad de dimensiones.</P> <P>Hay alguna otra forma de configurar la siguiente expresión que sea más ágil?</P> <P>:</P> <DIV>if(Indicador='PRODUCCION (Tm)' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV><SPAN> IF(Indicador='PRODUCCION (Tm)' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</SPAN></DIV> <DIV>&nbsp; &nbsp; IF(Indicador='PRODUCCION (Tm)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='Tm/TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV><SPAN> IF(Indicador='Tm/TOTAL EFECTIVOS' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</SPAN></DIV> <DIV>&nbsp; &nbsp; IF(Indicador='Tm/TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;if(Indicador='COSTE MANO DE OBRA (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='COSTE MANO DE OBRA (€/Kg)' AND ([acVar%. vs Presup.]&lt;=+0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='COSTE MANO DE OBRA (€/Kg)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='EFECTIVOS PROPIOS' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS PROPIOS' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS PROPIOS' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='EFECTIVOS ETT' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS ETT' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='EFECTIVOS ETT' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='TOTAL EFECTIVOS' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='TOTAL EFECTIVOS' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GASTO CEU (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='GASTO CEU (€/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='GASTO CEU (€/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND ([acVar%. vs Presup.]&lt;=+0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MATERIAL-AUXILIAR (€/Kg)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='MANTENIMIENTO(€)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MANTENIMIENTO(€)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='MANTENIMIENTO(€)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO GAS (Kwh/kg))' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO GAS (Kwh/kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO GAS (Kwh/kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO ELECTRICIDAD (Kwh/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND [acVar%. vs Presup.]&gt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND ([acVar%. vs Presup.]&lt;=0.0295 AND [acVar%. vs Presup.]&gt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(Indicador='CONSUMO FOTOVOLTAICA (Kwh/Kg)' AND [acVar%. vs Presup.]&lt;0.0295,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO MERCADONA (SERVIDO VS PEDIDO)' and (Real-Presupuesto)&gt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO MERCADONA (SERVIDO VS PEDIDO)' and (Real-Presupuesto)&lt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO OTROS CLIENTES (SERVIDO VS PEDIDO)' AND (Real-Presupuesto)&gt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='TASA SERVICIO OTROS CLIENTES (SERVIDO VS PEDIDO)' AND (Real-Presupuesto)&lt;0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND [acVar%. vs Presup.]&gt;0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND ([acVar%. vs Presup.]&gt;=-0.0295 AND [acVar%. vs Presup.]&lt;=0),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CIFRA DE VENTAS (€)' AND [acVar%. vs Presup.]&lt;-0.0295,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='HORAS EXTRAS (€)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS INTIES' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND [acVar%. vs Presup.]&lt;=0,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='QUEJAS L-900' AND [acVar%. vs Presup.]&gt;=0.025,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND [acVar%. vs Presup.]&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='CUMPLIMIENTO PLAN MEJORA PROCESOS (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND if(IsNull((acReal-acPresupuesto)/acPresupuesto),'0',(acReal-acPresupuesto)/acPresupuesto)&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vAmarillo,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='NIVEL DE MADUREZ (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND [acVar%. vs Presup.]&lt;=0,vColor_Fracaso,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND ([acVar%. vs Presup.]&gt;0 AND [acVar%. vs Presup.]&lt;0.025),vColor_Intermedio,</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(Indicador='GRADO AVANCE INDUSTRIALIZACION (%)' AND [acVar%. vs Presup.]&gt;=0.025,vColor_ActualExito</DIV> <DIV>)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))</DIV> Tue, 13 Jun 2023 15:08:24 GMT https://community.qlik.com/t5/App-Development/Expresi%C3%B3n-de-colores-muy-extensa/m-p/2083333#M88807 PepeOssa 2023-06-13T15:08:24Z