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

[pablolabbe]

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

[gferran]

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.

[pablolabbe]

Thanks Gabriel,

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

[#4]

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

[pablolabbe]

Problem fixed in 2.2.3