Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
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.