Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Arnec
Contributor III
Contributor III

Problem with converting currency

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

 

Labels (3)
1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

1 Reply
rubenmarin

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