Bad number format visualization

[#1]

Hi,

I have a problem with data visualization in QV. I extract data from OraOLEDB.Oracle and the number fields are visualized with a lot of additional zeros after decimal. For example, the field Storage_id  - which is a number - is displayed as 15 in my database but in qlikview as 15,00000000000000000000000....
This visualization is valid both in Preview Table and my objects and it creates me a lot of problem.
I don't understand the reason of it. How can I fix this problem without formatting the number?

Thank you

[kaushiknsolanki]

Hi,

     Try this function while loading data from your source system.

     Just an example.

load num(num#(Fields)) as Number inline [

Fields

1.00000000000

2.00000000000

3.00000000000

];

Regards,

Kaushik Solanki

[Anonymous]

Cristina

If you don't need any decimal places at all then try:

     Floor( yournumberfiled ) as yournumberfiled )

The QlikView Help explains the floor() function.

Best Regards,     Bill

[#4]

hi

try this

LOAD *,Left(F1,Index(F1,'.')-1)  as num INLINE [

    F1

    1.0000

    2.0000

    3.0000

    4.0000

];

see attached file.

[paulcalvet]

Hi,

For my part, I did this when I extract data :

LOAD num(`YourField`,'# ##0') AS YourField,

          num(`YourField2`,'# ##0,00') AS YourField2;

SQL Select

SQL SELECT YourField, YourField2 FROM...

Regards

[Aurelien_Martinez]

Hi,

You can just try :

Load

Field*1 as Field

;

SQL SELECT [...]

Regards

[#7]

I wouldn't format the field...I was thinking it was something from User Preferences or from

SET ThousandSep='.';
SET  DecimalSep=',';

I have too much fields with this problem and it would take too much time to format it one by one.

Thank you

[Anonymous]

Cristina

Unfortunately one often does have to do things that do take time.  But on the plus side that that is what keeps people like us in a job.

Getting things formatted properly in your load script and then saving the table in a QVD, allows later multiple re-use in dashboards & is a standard QlikView Best Practice, often referred to as a QVD Layer.

If you google QlikView QVD Layer, you'll get fair few hits explaining how to implement this.

Best Regards,     Bill

[#9]

simply try this

num(fieldname) as numberfield

[#10]

You're right, but my problem is why I can't visualize data as they are in my database. Those zeros are very strange.