Problem with converting currency

Arnec — Sat, 16 Nov 2024 19:11:25 GMT

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);

Re: Problem with converting currency

rubenmarin — Sat, 08 Feb 2020 09:06:23 GMT

Hi, if you want to convert text 16.36 to number 26,36 you can use: Num(Num#([Financial charge], '0', '.', ','))

topic Problem with converting currency in QlikView

Problem with converting currency

Re: Problem with converting currency