Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
_jespers_
Partner - Creator II
Partner - Creator II

Modify hypercube before export to Excel in Mashup

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

Labels (2)
0 Replies