
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excel Export - Numbers as Text
Hi guys...
I'm using QlikView Personal Edition version 12.10.20500.0 and when I export the content from a pivot table to the MS_Excel, Numbers as have been exported as Text. What can I do to overcome this issue?
- Tags:
- qlikview_deployment
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you go to the properties of the graphic in the tab number you can format the cell and export it as a number

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Tincholiver...
Your suggestion really worked. The strange situation is, before formatting the field, it already has a Number format. But after the forced formatting it was exported as Number.
Thank you very much !!!

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Keep in mind that when ExcelExportMixedAsText is 0 the numerical values will be exported based on the stored or calculated result, and not on the currently presented format in QlikView. This can be see in the example above where the 5% value is exported with the underlying numerical value of 0.05 and the two decimal value 800000.80 is exported with the underlying numerical value of 800000.8.
- Open QlikView Desktop Client
- Open the QVW file that requires the change
- Go to Help > About QlikView…
- Right click on the QlikView logo in the lower left corner of the about dialog
- Highlight ExcelExportMixedAsText in the settings list
- Enter the desired value to export mixed values as text (1) or numbers (0)
- Click Set to store the value
- Click Save Next Script on Load
- Click Close to close the settings dialog
- The limit has now been changed in the QlikView client, and will affect all QlikView applications opened in the client
- Change the QVW level setting as described in above section
- Save or publish the QVW to the QlikView Server Documents folder
- Open the QlikView Server’s settings.ini file in a text editor. Default file path; C:\ProgramData\QlikTech\QlikViewServer\Settings.ini
- Add ExcelExportMixedAsText =nnn in the [Settings 7] section of the settings file. Note that nnn should be replaced with the same value as specified in step 6 in above section
- Save the settings file and close text editor
- Restart QlikView Server, to trigger loading of the altered settings
- Access the QVW from QlikView web client to see that the behavior has been changed for all QlikView applications accessed through the server
Bill
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you go to the properties of the graphic in the tab number you can format the cell and export it as a number

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Tincholiver...
Your suggestion really worked. The strange situation is, before formatting the field, it already has a Number format. But after the forced formatting it was exported as Number.
Thank you very much !!!

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Keep in mind that when ExcelExportMixedAsText is 0 the numerical values will be exported based on the stored or calculated result, and not on the currently presented format in QlikView. This can be see in the example above where the 5% value is exported with the underlying numerical value of 0.05 and the two decimal value 800000.80 is exported with the underlying numerical value of 800000.8.
- Open QlikView Desktop Client
- Open the QVW file that requires the change
- Go to Help > About QlikView…
- Right click on the QlikView logo in the lower left corner of the about dialog
- Highlight ExcelExportMixedAsText in the settings list
- Enter the desired value to export mixed values as text (1) or numbers (0)
- Click Set to store the value
- Click Save Next Script on Load
- Click Close to close the settings dialog
- The limit has now been changed in the QlikView client, and will affect all QlikView applications opened in the client
- Change the QVW level setting as described in above section
- Save or publish the QVW to the QlikView Server Documents folder
- Open the QlikView Server’s settings.ini file in a text editor. Default file path; C:\ProgramData\QlikTech\QlikViewServer\Settings.ini
- Add ExcelExportMixedAsText =nnn in the [Settings 7] section of the settings file. Note that nnn should be replaced with the same value as specified in step 6 in above section
- Save the settings file and close text editor
- Restart QlikView Server, to trigger loading of the altered settings
- Access the QVW from QlikView web client to see that the behavior has been changed for all QlikView applications accessed through the server
Bill
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, Bill...
Your suggestion was really cool. Even more cause it showed me a new place where settings can be applied on QlikView.
Thanks a lot.
Giovane


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way to do the same in Qlik Sense , with or without Easter egg !?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @cotiso_hanganu,
As this thread is for QlikView and over 4 years old, suggest you start a new thread regarding your question on the Qlik Sense forums.
Best Regards
Help users find answers! Don't forget to mark a solution that worked for you!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The issue is actually in the support log for a month now. Once solved, you can make an article

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The easter egg sounds like it would create more problems than it would solve since it sounds like it applies to all dashboards on the server. Too risky to try that!
The fundamental problem here is that when users send a table to excel, they get a mess of green triangle tick marks and data that is text and cannot be used in calculations. So they have to convert to text manually.
The object -> properties -> Number -> Expression
Number Format Settings
option is not feasible when the data in the table has different formats for each column (this is common when reporting financial data along with numerical data)
But there IS a sort of solution. Users can be told to export instead of send to Excel. Right click on the table, then choose Export instead of just "send to Excel." This produces a .csv file which appears to work correctly!
In our experience, users don't see the little excel icon anyway on the title bar, so instructing them to right click/export is probably going to work.
