Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ninnartx
Creator
Creator

Decimal points when exporting to excel

Hi everyone, 


When I export data to excel, it seems like decimals are only exported if the data set is small. 

So I have a straight table with number formatted as follows: #,##0 

if the data set is small, when I export to excel and increase decimals on excel, the underlying decimals will show. 

However, if data set is large, when I export to excel and increase decimals, I only get 0 as decimal points. So it seems like only whole numbers are exported. 

When we sum those 2 columns, we get different results (very small but enough to raise eyebrows). 

 

Did anyone experience something similar / is this a known issue? 

Is using round() in my formula the only way to keep them consistent? 

 

Any help or suggestion would be greatly appreciated! 

Labels (2)
1 Reply
rwunderlich

The formatting functions format only the display.  So the underlying number exported may be different.  If you are getting inconsistent results than round() would be the way to go. round() changes the actual value. 

-Rob