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
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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: 
jordan231
Contributor II
Contributor II
‎2014-08-27 03:26 AM

Pivot table export to excel

Dears, I have a pivot table with number of dimmension fields. When i export numeric data into excel they turn into text format. Expresions keep the proper format. I tried to use round and num functions without success also seetings in sheet properties are correct. Does anyone has any idea ? Thanks for any hints.

621 Views
0 Likes
3 Replies
ashfaq_haseeb
Champion III
Champion III
‎2014-08-27 03:29 AM

Hi,

Right click on pivot table --> Properties --> Number --> Select your Expression --> and select numbers

Regards

ASHFAQ

522 Views
0 Likes
jordan231
Contributor II
Contributor II
‎2014-08-27 03:43 AM
Author

In response to ashfaq_haseeb

In pivot properties you can only change settings for Expressions i'm trying to handle Dimmension settings.

522 Views
0 Likes
ashfaq_haseeb
Champion III
Champion III
‎2014-08-27 03:48 AM

In response to jordan231

Attach sample qvw with data please and scenerio

Regards

ASHFAQ

522 Views
0 Likes