Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
TimmyCNHi
Creator
Creator

Unexpected result on KPI Indicator Threshold

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.

Labels (4)
1 Reply
TimmyCNHi
Creator
Creator
Author

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?