Data mismatch in excel and csv output

[#1]

Hi All

I observed that the same data when exported to csv and excel gives different summary results. This is because excel stores the decimals whereas csv doesnot.

Is there a way to handle this ? As it could be a great problem if users choose to export it to csv.

Please advise.

[ashfaq_haseeb]

Hi,

It worked like a char I tried with 11.2 sr6.

What version of Qlik you are on?

try by upgrading to 11.2 sr6.

Look at the attached files.

Regards

ASHFAQ

[#3]

version 11.20.11643.0 IR

[ashfaq_haseeb]

Please upgrade it to 11.2 sr6

Regards

ASHFAQ

[#5]

Ashfaq

Are you showing decimals on your dashboard?

This is how my data is -

The above data set, when exported to excel and csv has a diffrerence in the sum total as csv doesnot store decimals and excel does.

[ashfaq_haseeb]

Hi,

Yes, I have decimals too. I attached a sample file even.

If possible can you post your .qvw file here.

Regards

ASHFAQ

[#7]

Ashfaq

Please refer to the attachments.

The actual  total is $12398.04

But when I export to csv , it sums up to  $12398 due to rounding off.

[ashfaq_haseeb]

Hi,

Try below format.

$#,##0.00;($#,##0.00)

Look at the attached document.

Regards

ASHFAQ

[#9]

As mentioned earlier, the requirement is not to show decimals in the dashboard.

[rwunderlich · Accepted solution]

This appears to be the way it works -- but impacted by the User Export settings.

For Excel, both the internal raw value and the format is exported, as Excel has the capacity to hold both.

CSV can only hold a single value, no formatting info. "Setting, User Preferences, Export, Number Formatting" controls  what is exported to CSV. If you set it to "No Formatting", the raw value is exported. Otherwise the formatted display value is exported.

-Rob

http://masterssummit.com

http://robwunderlich.com