Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help please! Traffic light and conditional If

Hello!

I have a trouble, i am creating some traffic light in order to determine where is the level of the indicators. There are 4 fields.

Unacceptable, Deficient, Target and outstanding.

The first light turns red if the data is lower that the minimum level. and if it is higher than the minimum level but lower than the average it will be white. Here is the code:

If([KPI's de Incid 1]<[Límite inferior],Red(), White())

Average= 6 Minimum Level= 3 Data= 2

Now if the level is lower than the average but is higher than the minumum level it must be yellow.

If([KPI's de Incid 1]<Media,Yellow(),White())

Average= 6 Minimum Level= 3 Data= 4

Here is my question, i want to only see the red light if the data is lower than my lower minimum, actually ithe code works but if the data is for example 4 the two lights turn on, the yellow and the red one.

Any ideas how can i fix it? Also i have to do the same for the Average and the Higher Level

Thank you!

0 Replies