Modify hypercube before export to Excel in Mashup

_jespers_ — Tue, 25 Jan 2022 11:55:24 GMT

I'm using the .exportData-method (https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/TableAPI/exportData-method.htm) to export the values in a table to Excel.

I guess that the exportData-method uses the hypercube for the specified object when creating the Excel-file.

My question is if there is any way I can modify the hypercube and the export-method then uses that modified hypercube when creating the Excel-file?

I tried just changing the values in one of the cells in the qDataPages in the hypercube, but without any success

$scope.downloadFile = function($event){ qix.app.getObject('YQPd').then(function(object){ var qcx = object.layout.qHyperCube.qSize.qcx; var qcy = object.layout.qHyperCube.qSize.qcy; object.getHyperCubeData({ "qPath": "/qHyperCubeDef", "qPages": [{ "qLeft": 0, "qTop": 0, "qWidth": qcx, "qHeight": qcy }] }).then(function(data){ data[0].qMatrix[0][0].qText = 'Test'; object.layout.qHyperCube.qDataPages = data; qlik.table(object).exportData({download: true}); }); }); };

The export works, but the exported values are not the modified values in the hypercube.

Is there a way this can be achieved?

Regards

Jesper

topic Modify hypercube before export to Excel in Mashup in Integration, Extension & APIs

Modify hypercube before export to Excel in Mashup