topic Re: How to include "Export data" feature in a mashup in Integration, Extension & APIs

How to include "Export data" feature in a mashup

Fri, 17 Apr 2015 21:02:40 GMT

Hi everyone. I am new to creating mash ups and was wondering if I could get a solution to a issue I have come across.

I created a mashup using Qlik Sense Server Workbench. This mashup contains a table object from one of the sheets in my app. When accessing the sheet via the HUB, right clicking on the table shows an Export Data option for this table object. Is there a way for me to include this feature for this table in my mashup?

Thanks!

Re: How to include "Export data" feature in a mashup

Tue, 21 Apr 2015 17:46:13 GMT

Teena,

Have a look at the Engine API. In particular, this link here: http://help.qlik.com/sense/en-us/developer/#../Subsystems/EngineAPI/Content/WorkingWithAppsAndVisualizations/ExportData/…

Basically, you can create a hypercube (potentially hook into the hypercube of the object) and export the data from there.

Re: How to include "Export data" feature in a mashup

Aiham_Azmeh — Wed, 22 Apr 2015 16:55:53 GMT

Hi Jeffrey,

Can you make an example? It will be great to share it.

aiham

Re: How to include "Export data" feature in a mashup

Mon, 20 Jul 2015 17:40:04 GMT

Hi Jeffrey,

Can you please provide an example for mashup content here? We need this feature to make mashups more useful.

Ramendra

Re: How to include "Export data" feature in a mashup

Stefan_Walther — Tue, 21 Jul 2015 09:00:17 GMT

Hi,

here's an example how you could do that. This functionality is currently not documented nor supported, but in the next version of Qlik Sense it will be there:

Html:

<button id="cmdExport" style="display:none;">
   Export data
</button>
<div id="QV01" style="position: absolute; top: 50px; left: 20px; width: 200px; height: 200px;" class="qvobject"></div>

JavaScript:

require( ["js/qlik", "jquery"], function ( qlik, $ ) {
   qlik.setOnError( function ( error ) {
      alert( error.message );
   } );

  var app = qlik.openApp('Executive Dashboard.qvf', config);

  app.getObject('QV01','NaKQwM').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);
         });
      })
   });
} );

Re: How to include "Export data" feature in a mashup

Wed, 19 Aug 2015 09:33:10 GMT

Hi,

Please what is vizModel?

Re: How to include "Export data" feature in a mashup

Stefan_Walther — Wed, 19 Aug 2015 09:40:00 GMT

It is the model of the visualization object.

Re: How to include "Export data" feature in a mashup

Wed, 19 Aug 2015 09:44:45 GMT

Okay, thanks. I tried to follow your example, but it didn't work. Please what am I doing wrong?

Re: How to include "Export data" feature in a mashup

Stefan_Walther — Wed, 19 Aug 2015 09:52:49 GMT

As mentioned before, the above illustrated solution is not officially supported.

Starting with Qlik Sense 2.1 (which will be available soon) a new Client API will be available the so called "Table API" which then allows export of data:

var qTable = qlik.table(this);  
var $exportButton = $( document.createElement('button')); 
$exportButton.html('Export');


$exportButton.bind('click', function (  ) {
     qTable.exportData({download: true}); 
     }); 
$element.append($exportButton);

More about the Table API will then be available in the official documentation of Qlik Sense 2.1

Re: How to include "Export data" feature in a mashup

Wed, 19 Aug 2015 10:02:06 GMT

Oh, now I understand you, so it can't work yet until version 2.1? We will wait till then. However am I on the right path from the code I posted.

Re: How to include "Export data" feature in a mashup

Stefan_Walther — Wed, 19 Aug 2015 10:27:29 GMT

No, you can, just hadn't the time to have a look at the code you have attached above ...

Re: How to include "Export data" feature in a mashup

Wed, 19 Aug 2015 10:38:35 GMT

okay. I will appreciate if you could have a look at the code in your spare time.

Thanks.

Re: How to include "Export data" feature in a mashup

Wed, 19 Aug 2015 10:55:29 GMT

okay. I tested it in another browser and found out it works, but two things it exports to an excel sheet and its being blocked as a pop-up, that's why I couldn't find it in firefox. However If I want to export as an image, how do I go about that?

Re: How to include "Export data" feature in a mashup

Anonymous — Tue, 01 Nov 2016 20:27:03 GMT

Here it is:
extension:
https://github.com/stefanwalther/sense-export

Qlik help document:

http://help.qlik.com/en-US/sense-developer/3.0/Subsystems/Extensions/Content/Howtos/extensions-enable-export.htm

https://help.qlik.com/en-US/sense-developer/3.0/Subsystems/EngineAPI/Content/WorkingWithAppsAndVisualizations/ExportData/export-data-GO.htm

Re: How to include "Export data" feature in a mashup

Anonymous — Fri, 04 Nov 2016 02:00:19 GMT

Hi Stefan, I would like to use your Qlik extension "sense-export" to export data of a table to Excel.

However,the "sense-export" only supports no more than 10 dimensions, while there are 24 columns in my Qlik sense table.

I tried to change dimensions object in properties.js of Qlik extension "sense-export", however, it still does not work.

Could you please give any suggestion?

Thanks!

var dimensions = {

uses: "dimensions",

min: 0,

max: 22

};

var measures = {

uses: "measures",

min: 0,

max: 10

};

Re: How to include "Export data" feature in a mashup

Anonymous — Fri, 04 Nov 2016 02:03:45 GMT

Hi Adekunbi , could you please give any instruction about how to use your Dashboard.js to export data from Qlik table to Excel?

Thanks!

Re: How to include "Export data" feature in a mashup

Anonymous — Mon, 14 Nov 2016 22:11:00 GMT

Hi Stefan , I used the following method to create a button in Qlik sense mashup page to export data from Qlik sense table object.

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

var app = qlik.openApp('Executive Dashboard.qvf', config);

var $exportButton = $( document.createElement('button')).text('Export').appendTo('body');

var object = app.getObject('QV01','fzrxtjq');

object.then(function(model) {

var table = new qlik.table(model);

$exportButton.bind('click', function() {

table.exportData({download: true});

})

});

It works well in my local Qlik sense desktop, and it also works in Qlik sense server when I keep logging in Qlik sense server.

However, after I published the mashup at Qlik sense server with anonymous access, the "export" does not work any more in Qlik sense mashup page.

Could you please give any suggestion?

Thanks!

Re: How to include "Export data" feature in a mashup

Mon, 14 Nov 2016 22:56:30 GMT

‌Haikuo,

im not positive but my guess is that anonymous is not allowed to export data because of security rules. I'd check security rules to see if anon has access to export data.

Re: How to include "Export data" feature in a mashup

Anonymous — Wed, 16 Nov 2016 23:32:54 GMT

Hi Jeffrey , thanks so much for your help!

I am not quite familiar with Qlik server.

Could you please give any further instruction about check/set security rules in Qlik server to export/download data from Qlik mashup page?

Re: How to include "Export data" feature in a mashup

Anonymous — Wed, 16 Nov 2016 23:33:13 GMT

Hi Jeffrey , thanks so much for your help!

I am not quite familiar with Qlik server.

Could you please give any further instruction about check/set security rules in Qlik server to export/download data from Qlik mashup page?