topic Re: Export to Excel returning an empty spreadsheet in QlikView

Export to Excel returning an empty spreadsheet

Adam_Smith — Tue, 15 Mar 2022 23:15:18 GMT

Hi,

We have a Qlikview App which is being deployed to our Qlik SAAS cloud hub.

There is one particular chart which, when I try to export to excel it always returns an empty Excel spreadsheet.

I have tried to filter the results to a smaller sample, but still getting an empty Excel spreadsheet.

I am able to export other similar charts within the same Qlikview App to Excel.

If i open the same Qlikview App from the Qlikview Access Point rather than the Qlik SAAS cloud hub, I can export the data from this chart to excel.

Any ideas what might be causing this?

Re: Export to Excel returning an empty spreadsheet

Daniele_Purrone — Wed, 16 Mar 2022 07:14:31 GMT

Hi @Adam_Smith,
a couple of questions:

is the app still staged, or is published?
if you duplicate the chart, does the export work?

Thanks!

Re: Export to Excel returning an empty spreadsheet

Adam_Smith — Wed, 16 Mar 2022 23:04:59 GMT

Hi @Daniele_Purrone,

1. The app is published.

2. I tried to duplicated the chart. This didn't exactly fix the issue, but it did help me find the cause.

The chart had a calculation condition set. If I republish the app when the calculation condition is true, I can export the data. But if republish the app when the calculation condition is false, and then set the calculation condition to true within the app, I can see the data but cannot export the data.

For now I have removed the calculation conditions on this chart and all is working fine.

Thanks for your help.

Re: Export to Excel returning an empty spreadsheet

Daniele_Purrone — Thu, 17 Mar 2022 05:26:35 GMT

Thanks to you, @Adam_Smith !