topic Re: Unable to export to excel in Qlik Sense mashups. in Integration, Extension & APIs

Unable to export to excel in Qlik Sense mashups.

10dulkar — Sun, 02 Sep 2018 13:16:03 GMT

Hi All,

I have my Qlik Sense report converted into a mashup which is deployed to QAP set up.

I need to have my charts & tables exported to excel for which I have tried the below jQuery code :

require( ["js/qlik", "jquery"], function ( qlik, $ ) {

qlik.setOnError( function ( error ) {

alert( error.message );

} );

var app = qlik.openApp('d5d74472-04f9-4add-9002-7925e504ab2c', config);

app.getObject('QV01','WTjpK').then( function( vizModel ) {

// Prevent clicking on the button too early

//$('#cmdExport').show();

$('#cmdExport').on('click', function() {

         vizModel.exportData().then(function( reply ) {


            console.log('qUrl', reply);

            window.open(reply.result.qUrl);

});

However, I am getting the below error :

Unable to get property 'qUrl' of undefined or null reference.

Any help would be much appreciated.

Re: Unable to export to excel in Qlik Sense mashups.

Aiham_Azmeh — Mon, 03 Sep 2018 06:09:01 GMT

Hi 10dulkar‌,

The model reurned from `QApp.getObject` - is not supported. The way you can do exportData with the capability APIs is by using Table API => https://help.qlik.com/en-US/sense-developer/June2018/Subsystems/APIs/Content/CapabilityAPIs/TableAPI/exportData-method.htm

The table model is also exposed in Visualization API so should be able to do:

var app = qlik.openApp('d5d74472-04f9-4add-9002-7925e504ab2c', config); 
  app.visualization.get('WTjpK').then( function( vizModel ) { 
      visModel.show('QV01');
      // Prevent clicking on the button too early 
      //$('#cmdExport').show(); 
      $('#cmdExport').on('click', function() {   
         vizModel.table.exportData().then(function( reply ) {     
            console.log('qUrl', reply);    
            window.open(reply.result.qUrl); 
         }); 
      }); 
   });

I hope this helps

Re: Unable to export to excel in Qlik Sense mashups.

10dulkar — Tue, 04 Sep 2018 02:32:49 GMT

Hi Aiham,

This definitely helps! Thanks a lot!! But I still need help in 2 things :

1) Getting the below pop-ups while browsing the mashup, once we click on the "OK" button, everything works fine.

How do I get rid of these pop-ups?

2) Export to excel happens but the dump gets exported to the "tempcontent" folder on my QS Server.

If we were to publish the mashup & the end user were to view the mashup through a URL; will the export still work? Where will the export dump get stored then?

Please help me with the above questions.

Re: Unable to export to excel in Qlik Sense mashups.

Aiham_Azmeh — Wed, 05 Sep 2018 06:08:05 GMT

Hi Mahesh, (sorry for late reply)

1) this shouldn't happen - it looks like you are trying to open an app that doesn't exists - or have no access rights to it? I don't know for sure

2) assuming that the user is authenticated correctly, yes - you may probably need to build the URL since the mashup is deployed elsewhere, something like:

 vizModel.table.exportData().then(function( reply ) {       
            console.log('qUrl', reply);      
            window.open('https://[your-qlik-server]/'+reply.result.qUrl);

I hoe this helps

Re: Unable to export to excel in Qlik Sense mashups.

10dulkar — Wed, 03 Oct 2018 01:50:19 GMT

Thanks Aiham! This was very helpful & I was able to sort the issue out...