Different values in an original excel file and in qvd - why?

[#1]

Hello,

I have the following problem:

in excel file i have a column named gpn.

GPN is a calculated column, but in excel it appears as a result of calculation.

So in this column i have value 5.6 for some row. Why in qvd this value turns to be different?

In qvd this value turns to be 4.75....

Thanks a lot!

[#2]

Hi,

attached:

1.zip of csv original file.Please unzip it.

2.QVW for loading this file.

column 57 in csv file is revenue net and column 58 is gpn- both of them have the problem I wrote about- correct value in csv and wrong and different value in qvd.

Thanks

[whiteline]

Hi.

How do you compare the values from Excel and from qvd ?

You don't have the rowid or something similar. How can you be sure that you compare the right rows ?

[#4]

Hi,

I compare totals from column 57 as revenue net, 58 as gpn between excel and qvw.

Do you manage with this?

[#5]

Hi, any news for me?

Thanks.

[its_anandrjs]

Hi,

What problem you are facing in the column 57 and 58 and how you compare it after qvd creation let me know.

Regards,

Anand

[#7]

Hi,

I face a problem that if i sum values in column 57 in excel and make totals fro same column(revenue net) in qvd i get different results...

[Clever_Anjos]

Please check your values,

Are some like 9.5000000000000005E-5, these values maybe are getting differently converted by Excel and QV.

Is it possible to format these numbers?

[its_anandrjs]

Hi,

I suggest if possible please update your csv file specially 57 column and change is type to number upto 2 or 3 decimal place value then reload it with qvw application and then you see the changes in sum.

HTH

Regards,

Anand

[Gysbert_Wassenaar]

The precision of the numbers in the csv file seems to be higher than excel can handle. So if open the csv file in a text editor and compare the value with qlikview you'll see the same numbers. But afaict excel just displays less decimals. It's a display problem only. The data in the csv is the same as in qlikview as far as I can tell.

[#11]

Hi, I did it and it helped , but I can׳t do it for 400 files which I load to the model.

נשלח מה-iPhone שלי

ב-9 בנוב 2012, בשעה 19:44, "its.anandrjs" <qcwebmaster@qlik.com> כתב/ה:

QlikCommunity

Re: Different values in an original excel file and in qvd - why?

created by its.anandrjs in Development (QlikView Desktop) - View the full discussion

Hi,

I suggest if possible please update your csv file specially 57 column and change is type to numer upto 2 or 3 decimal value then reload it with qvw application and then you see the changes.

Regards,

Anand

Reply to this message by replying to this email -or- go to the message on QlikCommunity

Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity

© 1993-2011 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA