Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
dennemanr
Contributor II
Contributor II

Variable assignment results in different notation for positive and negative values.

Hello,

I've run into something strange with value assignment of variables. The notation of a negative variable differs from that of a positive one. The following script results in vPos = 0.05 where vNeg = -0,05. This is problematic when using the variable in charts.


The expected result is vPos = 0.05 and vNeg = -0.05. Instead of the comma notation in vNeg.

I'm running the Qlik Sense Novermber 2025 patch 2.

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY hh:mm:ss[.fff]';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='nl-NL';
SET CreateSearchIndexOnReload=1;
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
SET LongMonthNames='januari;februari;maart;april;mei;juni;juli;augustus;september;oktober;november;december';
SET DayNames='ma;di;wo;do;vr;za;zo';
SET LongDayNames='maandag;dinsdag;woensdag;donderdag;vrijdag;zaterdag;zondag';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';


let vPos = 0.05;
let vNeg = -0.05;
 

case.png

 

Labels (1)
1 Solution

Accepted Solutions
dennemanr
Contributor II
Contributor II
Author

I've figured it out.

The - in -0.05 performs and operation after which the value changes to respect the decimal point notation in the script. When vPos is written as 1*0.05 the notation changes to 0,05 as well.

View solution in original post

1 Reply
dennemanr
Contributor II
Contributor II
Author

I've figured it out.

The - in -0.05 performs and operation after which the value changes to respect the decimal point notation in the script. When vPos is written as 1*0.05 the notation changes to 0,05 as well.