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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-05-13 06:17 AM

Export to Excel - Keep Number Format

Hi I have a variable to calculate a percentage for a pivot chart :

num(sum(Number)/sum([Line Total]),'#,##0.0%')

When I try to export the pivot to Excel all the numbers are formatted as text.  How can I keep the number format??

Many thanks,

Tom

602 Views
0 Likes
0 Replies