topic Number format is not preserved while exporting the data. in Integration, Extension & APIs

Number format is not preserved while exporting the data.

s29124141 — Mon, 01 May 2017 16:15:08 GMT

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.

Re: Number format is not preserved while exporting the data.

Alexander_Thor — Mon, 01 May 2017 17:00:09 GMT

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

Re: Number format is not preserved while exporting the data.

DouglasR — Fri, 21 Jun 2019 20:25:25 GMT

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

Re: Number format is not preserved while exporting the data.

DouglasR — Fri, 21 Jun 2019 20:30:39 GMT

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