Change indicator color inside a table

Wed, 25 Nov 2020 16:16:04 GMT

Hello my dears.

Currently I have one object in my document which its main goal is to represent the stores that do not have any data during the current month.

I achieve this by using the following expression in a table:

=Isnull(Max({<Año = {$(=Max(Año))}, Num_Mes = {"$(=Max({<Año = {$(=Max(Año))}>} Num_Mes))"}, Id_Canal={4}, Id_Clasificacion={1,2}, Id_Modelo_Negocio-={6},
Id_Transaccion -= {0}>} Num_Mes))

The "-1" value is replaced by a "Traffic Light Gauge". The object is functioning correctly. The problem is that I need to replace the red dot by a blue one under 2 conditions:

1. The day of the week must be sunday

2. The stores must be included in a set that I could define in a set analysis expression.

¿How can I achieve this? ¿Is it possible?

I Attached the document, You can browse it using the user "DireccionTH" and the password "Adth1106"

Re: Change indicator color inside a table

ajsjoshua — Thu, 28 Apr 2016 06:55:28 GMT

Hi,

Try this

if(match(Isnull(Max({<Año = {$(=Max(Año))}, Num_Mes = {"$(=Max({<Año = {$(=Max(Año))}>} Num_Mes))"}, Id_Canal={4}, Id_Clasificacion={1,2}, Id_Modelo_Negocio-={6},
Id_Transaccion -= {0}>} Num_Mes)) <0 ) , red(),

blue() )

topic Re: Change indicator color inside a table in QlikView

Change indicator color inside a table

Re: Change indicator color inside a table