topic Re: [Bug] missing data when exporting table from Qlik Sense to Excel in App Development

[Bug] missing data when exporting table from Qlik Sense to Excel

pablolabbe — Fri, 05 Feb 2016 13:44:55 GMT

Hi,

I found an issue in Qlik Sense when exporting data to excel. I found the issue when user exported data from tables and table have expressions with set analysis created to show a comparative analysis based on actual year and previous.

The dimension labels on each row doesn´t show if there is no data from current selection (actual year) even if there is data for previous year. The Measures are exported fine.

The expression for previous year is very simple : sum({<Year={$(=Max(Year)-1)}>} Sales).

So my conclusion is: The dimension label are only exported for data associated to the current selection, and not the combination of the data created by set analysis expressions of all measures on the object.

I'm trying to create a workaround with no success.

Have found this issue on version 2.0.6 and 2.1.1

Regards,

Pablo Labbe

Re: [Bug] missing data when exporting table from Qlik Sense to Excel

gferran — Fri, 05 Feb 2016 14:55:27 GMT

Pablo,

I've been testing it and my conclusion is the same. I left here these images to show the problem.

App:

Excel with missing category:

Regards.

Re: [Bug] missing data when exporting table from Qlik Sense to Excel

pablolabbe — Fri, 05 Feb 2016 18:08:16 GMT

Thanks Gabriel,

Good to know i´m not the only one with this problem, so it´s more easy to fix.

Re: [Bug] missing data when exporting table from Qlik Sense to Excel

Tue, 12 Apr 2016 16:13:11 GMT

Hi Pablo - Were you able to resolve this issue?

I'm getting a similar problem with export of data to excel.Display on the application is working fine...

Ridham

Re: [Bug] missing data when exporting table from Qlik Sense to Excel

pablolabbe — Tue, 12 Apr 2016 18:45:42 GMT

Problem fixed in 2.2.3