Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export value precision


Hi, can anyone please help me. I have just noticed that when i export my data into excel it sums up to a different total to my QlikView reports. The problem appears to be that the data in Qlikview is to 3 decimal places but when I export it into excel it rounds up to the nearest integer. Settings on both reports are set to money formatted to £ and no decimal places. Any idea how i resolve this as i can't see any settings to change other than the display format of money?

4 Replies
richnorris
Creator II
Creator II

Did you ever figure this out? I'm facing the same issue. Cheers.

ashfaq_haseeb
Champion III
Champion III

Hi,

You may try with below options specified in this post look at rob reply.

http://community.qlik.com/message/558608#558608

Regards

ASHFAQ

Not applicable
Author

Yep Richard, It was all around the formatting. Stupidly because I had formatted the cells to zero decimal places it exports at zero decimal places and then because you have lost the roundings then it gives you a different total. As such I changed the format to 5dp and it was fine. However, report looks stupid in QV now. Must be a quirk of the system. Frustrating

Not applicable
Author

Thanks Ashfaq