Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shrutithakur297

Export data exporting wrong values in excel

Hello team,

I am exporting data from table in qliksense but when I am opening it in excel it is coming as incorrect. Can someone please help me with the issue.

I have added screenshot below.

1 Reply
balabhaskarqlik

Seems like number format in Sense is working correctly in Excel only when using custom format, not when creating format inside field expression. Custom format can be defined by field so I think you can use custom format instead of expression format.

May be you have created some of the expression fields as dimension. You can not define number format in dimension field, so please use always number field as measure.

OR

To convert in Excel, click column A, Column B and change the format to Time

Then select Data|Text to columns and click Finish

Instead of using Send to Excel:

If you are using the IE PlugIn, you can right-click and choose Copy to Clipboard|Full Table. Then paste into Excel

     Or

Right-Click and Export to csv. Then open in Excel.