Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
blink
Contributor II
Contributor II

Export data from Pivot Table in a mashup

Hi everyone,

 

I'm building a Qlik Sense mashup. The mashup has several tables ("VizlibTable" and  "VizlibPivotTable").

I'm using a Capability API's exportData method to export data. It works great for charts and tables, but it doesn't work for Pivot tables. For Pivot tables I always get an error:  { code: 13001, message: "no data" } .

 

The questions are: Why I get this error? and How can I export data from pivot tables in a mashup?

 

Thanks in advance

Labels (3)
1 Reply
blink
Contributor II
Contributor II
Author

I've found out that my exportData() request has different handle from other this table requests, like pagination.

I get a model using Capability API's getObject() method. Then I use the model to make an exportData() request.

const model = await application.getObject('htmlId', 'tableId';)

model.exportData(options);

This request has handle (54) and it ends with an error. As you can see on the image, the pagination request has another handle (59).

blink_1-1655996197445.png

All other charts and tables in the mashup works fine, I can export data. But I can't do it for "VizlibPivotTable". Any ideas why is this happening?