Hi there
I'm having some trouble converting a currency with . as the decimal separator. Please view my code below. I would rather not change the variables as these work for the rest of the application. I've added a screenshot with the current outcome so you can see what's going wrong. What I need is to convert the [Financial charge] field to a value in which the Money separators are as defined in the variables.
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='h:mm:ss';
SET DateFormat='D/MM/YYYY';
SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='ma;di;wo;do;vr;za;zo';
LOAD
date(Date#([Creation date], 'MMM D, YYYY'), 'DD/MM/YYYY') as Chargebackdate,
[Financial charge],
Num#([Financial charge],'#.##0,00') as Chargebackamount,
[Issue type],
Status,
EAN,
[Purchase Order Code]
FROM
[E:\Qlikview Storage\Data\Csv\Chargebacks.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);
