Number format is not preserved while exporting the data.

[s29124141]

Hi All, When the data is exported using below method, the formatting is not preserved in the exported data as shown below. Could anyone please help me out here?

Code to export the data of existing visualization.

var Export = function () {
  table.OnData.unbind(Export);
  table.exportData({ format: 'OOXML', download: false }, function (link) {
  window.open('http' + (config.isSecure ? 's' : '') + '://' + config.host + ':' + config.port + link, '_blank');
  });
};


app.visualization.get($(chart).attr('data-qlik-objid')).then(function (visual) {
  table = qlik.table(visual.model);
  Export();
});

Exported data shown without formatting in excel.

Number format shown properly in the visualization.

[Alexander_Thor · Accepted solution]

Hey,

In Qlik we have the Dual format that contains the text value and the numerical value of a data point.

In this case the textual value is what you see on the screen but the underlying numerical value is what gets exported.

A workaround is to wrap your expression in Text() or Money() to force Qlik to use the textual representation of the number for export.

See: Qlik Export Method | Qlik Community

[DouglasR]

Hey, I'm trying to get the kpi formatted value, but I can only get the numerical value from the app.vizualition callback.

How can I use that Text() method on a mashup?

Thanks

[DouglasR]

Just for a little more info, what I want to do is get the kpi values as is on the graphics, so I can use those formatted values on mashup. I am not actually showing those graphics on my webpage