NUM Probelm

[fkeuroglian]

Hi, i have a qvw and have problem with num

i bring info from a qvd and i try to put number format to sum but i have problems

please help, if anybody can!

thank you!

i atttached a qvw wit the 2 examples numbers that i have problem, 

Field0_Material= 224097001 OR Field0_Material= 222290;

correct is:

224097001 =80

222290=3455,51

i have to sum , in each is correct one and wrong the other

please help with this format!

thank you!

Fernando

[fkeuroglian]

I do not why, this is the problem i have!

i dont understand it

[Anonymous]

Fernando,

The issue is with the data, not Qlikview, so I would suggest looking at the source data.  If it is correct in the source, perhaps in the .qvw generating this QVD the decimal separator is defined as "." instead of ","

Regards,
Sean

[fkeuroglian]

Sean

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='$U #.##0,00;($U #.##0,00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';

SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

Set Path_QVD='../QVD/';

Set Path_Recursos='../Recursos/';

it is strange,not?

[Anonymous]

Fernando-

Can you query the source table (ZRM07MLBS) and confirm the correct value is stored there?  I am guessing that it is stored incorrectly as 80.000 in your source database.

Regards,
Sean

[Anonymous · Accepted solution]

use floor() function to remove the decimal places from 3.445,51 to 3.445 floor(Num(Value,'#.##0')) and use this format in the num function to achieve the desired format Num(Value,'#.##0')

[fkeuroglian]

Steven, Sean and Walid

Thank you for all your support and help, it was a problem with the source and the solution i have to implement is transform all the data before create the qvd, i transformate all after create the qvd, but if i do it befero works and transform ok!

thank you a lot!

Fernando

[stevedark]

Glad it's now working.