Problem with thousand separator when importing XML file

Wed, 09 Dec 2009 22:34:49 GMT

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

topic Problem with thousand separator when importing XML file in QlikView

Problem with thousand separator when importing XML file