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: 
SterreKapteijns
Partner Ambassador
Partner Ambassador

Rounded numbers in export Vizlib pivot table to Excel

Hi!

I have exported a Vizlib pivot table to Excel. 

Unfortunately the numbers in one column are rounded in the export: 

SterreKapteijns_0-1692108067409.png

And in Excel:

SterreKapteijns_1-1692108137950.png

It shows as 15% even though the cell has the right number, the format of the cell is "Custom", even though in Qlik it is a number. 

Does anyone know how to change this? I have already tried Num() and changing the decimals.

Thanks in advance!

 

Labels (2)
1 Solution

Accepted Solutions
Alan_Slaughter
Support
Support

Hi, I would suggest contacting Vizlib support, for your questions with Vizlib.
https://community.vizlib.com/support/home

View solution in original post

1 Reply
Alan_Slaughter
Support
Support

Hi, I would suggest contacting Vizlib support, for your questions with Vizlib.
https://community.vizlib.com/support/home