Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.