Export data from a chart object to Excel creates multiple Excel sheets
Article Number: 000078785 | Last Modified: 2019/07/12
When a user exports data from a chart object to Excel, it may create multiple sheets.
The reason why several sheets are created in the data export is because the object contains multiple "hypercubes". One hypercube for the dimensions and measures added by the user (the "base" cube) and then for some chart types 1 or 2 hypercubes are generated "behind the scenes". Engine exports data from all hypercubes in the object - each on a separate sheet.
Note: The number of hypercubes are fixed depending on chart types and data in created excel sheets is not always the same as they exported different hypercubes.
This is expected behavior in Qlik Sense