Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using the .exportData-method (https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/APIs/Content/Sense_ClientAPIs/Capabil...) 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