topic Re: Integrate thresholds from table into if-function in QlikView

Integrate thresholds from table into if-function

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Integrate thresholds from table into if-function

Anonymous — Wed, 19 Oct 2016 19:01:26 GMT

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

Re: Integrate thresholds from table into if-function

Thu, 20 Oct 2016 08:01:11 GMT

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!

Re: Integrate thresholds from table into if-function

Anonymous — Thu, 20 Oct 2016 16:46:04 GMT

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

Re: Integrate thresholds from table into if-function

Anil_Babu_Samineni — Thu, 20 Oct 2016 16:50:05 GMT

Would you describe atleast those Variables