traffic light gauge with dynamic limits

Wed, 14 Jun 2017 13:34:15 GMT

Hi people,

I'm using a traffic light gauge to know if my varible "Actual" is higer, lower or in the middle of a range. But Actual's values have differents ranges to compare it, so i try this in segment configuration:

0 for Red

=if([INDICADOR ]='Porcentaje Global de Adecuación al Perfil',

sum({<[INDICADOR ]={'Porcentaje Global de Adecuación al Perfil'}>}[RANGO BAJO]+1),

if([INDICADOR ]='Índice de personal con brecha de competencias PEQUEÑA o INEXISTENTE',

sum({<[INDICADOR ]={'Índice de personal con brecha de competencias PEQUEÑA o INEXISTENTE'}>}[RANGO BAJO]+1),0)) --- For yellow

=if([INDICADOR ]='Porcentaje Global de Adecuación al Perfil',

sum({<[INDICADOR ]={'Porcentaje Global de Adecuación al Perfil'}>}[RANGO ALTO]+1),

if([INDICADOR ]='Índice de personal con brecha de competencias PEQUEÑA o INEXISTENTE',

sum({<[INDICADOR ]={'Índice de personal con brecha de competencias PEQUEÑA o INEXISTENTE'}>}[RANGO ALTO]+1),0))--- For green.

It works when i select one of these "Indicadors" but, if i unselect one of these, the traffic light doesn't work.

Here is the file wich i'm working:

Re: traffic light gauge with dynamic limits

thomaslg_wq — Wed, 14 Jun 2017 15:15:17 GMT

Hi Andrés,

How can you show at the same time several kpis in an only one trafic light gauge ? No way I can do this...

Maybe an example of what you want at the end would help us.

BR,

Thomas Le Gall

topic Re: traffic light gauge with dynamic limits in QlikView

traffic light gauge with dynamic limits

Re: traffic light gauge with dynamic limits