Issues with exporting data to Excel in QlikSense

[Anonymous]

In QlikSense, when we export data of a chart / table , the measure values doesn't appear in the proper format. I want to see the values as numbers but it gets displayed in the 'e' format. Some times the numbers are shown as text in Excel.

This is not working out even if we apply num format (we know this is used for proper number representation in UI only).

If we use Round function values are mismatching with some decimal number differences.

I think qlik should have a mechanism to export data with proper formatting.

Thanks

Chenna

[Anonymous]

Hi Chenna,

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.

By the way, I noticed that 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.

BW,

Markus