Unexpected result on KPI Indicator Threshold

TimmyCNHi — Sat, 16 Nov 2024 02:23:35 GMT

Hi everyone! First time poster and beginning to explore the wonderful world of Qlik Sense 🙂

I've been struggling with the Indicator Threshold in the Vizlib KPI builder.

The code I'm using is the following:

=Avg({<KPI={'VBV''s'}>}Doel)

I've used this code successfully in the 'target-value' layer as it shows "6,5". When I manually type "6.5" in the Indicator Threshold box for the 'YTD-value' layer, the conditions (greater than icon, less than icon & equal icon) react perfectly as expected. But when I use the above code in the Indicator Threshold, it always shows the equal icon (doesn't detect a correct value).

I appear to be using KPI Designer 1.8.0.

Re: Unexpected result on KPI Indicator Threshold

TimmyCNHi — Wed, 20 May 2020 07:20:40 GMT

Well, as I suspected, setting the following parameters in Data load editor did seem to fix it:

SET ThousandSep=',';
SET DecimalSep='.';

Yet this isn't an ideal solution. Is there any way I can clarify to this extension that it should consider a comma as decimal separator?

topic Re: Unexpected result on KPI Indicator Threshold in Integration, Extension & APIs

Unexpected result on KPI Indicator Threshold

Re: Unexpected result on KPI Indicator Threshold