Integrate thresholds from table into if-function

[#1]

Hi everyone,

could you tell me what's the best way to integrate the KPI thresholds (green, red) for the respective KPIs in the following script? The values are located in an Excel that will be regularly updated (manually).

To make it perfectly clear:

Row 1: KPI names

Row x: Threshold values green (formatted like >=value or <value)

Row y: Threshold values red (formatted like >=value or <value)

=if(vVARIABLEcurrentperiod-vVARIABLEpreviousperiod>0,
'qmem://ImageID/Green_indicator',
if(vVARIABLEcurrentperiod-vVARIABLEpreviousperiod<0,
'qmem://ImageID/Red_indicator',
'qmem://ImageID/Orange_indicator'))

Thanks in advance!

[Anonymous]

If you want to do this graphic, is an example with multiple segments.

[#3]

Hi Marcio,

thanks for your answer. I simply want to "pull" the KPI threshold value (e.g. ">=0.94) from the table into the if-formula, that triggers the color of the graphic. Do you also have a solution for this?

Thanks!

[Anonymous]

carloandrae, You can send an example for me to see?

[Anil_Babu_Samineni]

Would you describe atleast those Variables