Problem with thousand separator when importing XML file

Ask a Question

Hello,

I'm facing a problem when trying to import an XML file into QV. This XML file contains info from website activity.

I've created a .qvd database form this file. When I try to import it from my .qvw report, it works but I do not manage to have the figures over 999 properly.

They are considered as text - i don't know why, it seems that the thousand separator is not correctly understood.

This is the code that I tried :


Direct_sources:
LOAD Value,
 if (istext(Value), 'Y', 'N') as flag_text,
 if (isnum(Value), 'Y', 'N') as flag_num,
 replace (text(Value), '', '') as New_value,
 if(istext(Value), replace (text(Value), '', ''), Value) as New_value2,

 Label as Date_complete,
 subfield(Label, ' ' ,1) as NomJour,
 subfield(Label, ' ', 2) as Jour,
 subfield(Label, ' ', 3) as Mois,
 subfield(Label, ' ', 4) as Année
FROM C:\QVData\Source\Direct_sources.qvd (qvd);

It's a simple 2 columns chart : "Value" is the number of pages viewed and "Label" is the date.

If you have any idea, thank you to let me know...

Kind regards,

Gaithe

0 Replies