topic Re: Story not keeping selections when exported to Powerpoint in App Development

Story not keeping selections when exported to Powerpoint

colinh — Thu, 03 Aug 2017 09:03:50 GMT

I've created a story with two embedded sheets, both are the same sheet with different selections made. In story presentation mode in Sense they work fine - sheet 1 shows the embedded sheet with one set of selections, sheet 2 shows the embedded sheet with the second set of selections.

When exported to Powerpoint or PDF however, both sheets show the same selections. They seem to take the selections of the second sheet.

Is there a solution to this, or is it a bug? This is on server, June 2017 release, and on desktop June 2017.

Thanks

Re: Story not keeping selections when exported to Powerpoint

colinh — Wed, 13 Sep 2017 09:24:03 GMT

For future reference, turns out this was a bug, resolved in June 2017 patch 2:

Exporting to PDF only retains the value of selections of the active sheet Jira issue ID: QLIK-58913 Description: PDFs retain only the selections on the active sheet of the story rather than the selections as presented in the story.

Re: Story not keeping selections when exported to Powerpoint

amien — Thu, 18 Jan 2018 22:29:41 GMT

Is this bug back again in the november 2017 release (patch 1 and 2)?

Re: Story not keeping selections when exported to Powerpoint

colinh — Fri, 19 Jan 2018 06:53:52 GMT

I've just tested in the November release and yes, it looks like this bug is back. It's different though, previously if you embedded the same sheet in a story multiple times with different selections, the selections were retained in the story, they were just lost when exporting to Powerpoint. Now it looks like the selections are lost when the sheet is embedded, so it shows the same on each sheet when the story is run, which is even worse.

Hopefully to be fixed in patch 3 or the next release.

Re: Story not keeping selections when exported to Powerpoint

amien — Fri, 19 Jan 2018 08:30:29 GMT

We can't wait this long. This bug is also in the initial and Patch1 release. It's really hard to understand that this is not noticed or solved in patch 2. Our customers use this functionality every day. I need to do a roleback

Re: Story not keeping selections when exported to Powerpoint

amien — Sun, 21 Jan 2018 20:07:43 GMT

i tried alot of things to create a workaround .. nothing worked

Re: Story not keeping selections when exported to Powerpoint

colinh — Wed, 21 Feb 2018 07:35:13 GMT

This seems to be fixed in the February 2018 release. Selections are retained in the story and in the export to Powerpoint.

Re: Story not keeping selections when exported to Powerpoint

Anonymous — Wed, 14 Mar 2018 06:19:21 GMT

This appears to still be broken in the February 2018 release. Not only are filter selections lost when exporting, they are also lost when moving between pages in a story (I'm unsure if the latter is intentional but it seems odd).

Re: Story not keeping selections when exported to Powerpoint

amien — Wed, 14 Mar 2018 20:14:46 GMT

i created a bug support ticket for this. result : this is not going to be fixed. But i works now as intended. the other option (keeping the selection when exporting a story) was the bug

i suggest to keep both options

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Wed, 23 Jan 2019 17:55:13 GMT

In the Latest release the exporting of stories to powerpoint and PDF is very very erratic. When you embed the same sheet with different selections half of the time the filters change and half of the time they don't. It seems that some browsers work better then others. Chrome seems to behave the way you would expect with the export matching what you see but I.E. 11 is all over the map.

Re: Story not keeping selections when exported to Powerpoint

cchristenson2 — Tue, 14 May 2019 17:17:58 GMT

Anyone still having this issue? We just tested and had issues similar to those outlined above.

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Tue, 14 May 2019 18:27:59 GMT

Yes, It is really causing us significant problems. We upgraded to April 2019 and it isn't fixed. In fact now we are having problems exporting in Chrome as well.

Re: Story not keeping selections when exported to Powerpoint

cchristenson2 — Tue, 14 May 2019 18:47:33 GMT

Thanks Tim. We are going to submit a ticket to Qlik and see what happens.

Re: Story not keeping selections when exported to Powerpoint

QT — Fri, 17 May 2019 18:05:09 GMT

So I think there are multiple scenarios mentioned in this thread, but I can provide some input based on what I found to address one of the scenarios and what I think is happening behind the scenes.

Scenario 1: You are creating multiple sheet Story, but the selections applied to each story seems to be all the same, rather than what you had selected in Analysis

Scenario 2: You have created a story and when replaying the Story, you have made some new selections. Then you try exporting thinking that the selections during the replay would be applied

I'm sure there may be other scenarios, but this is what I've encountered in the 2019 releases.

This workaround is for Scenario 1

When you embed a sheet into a story, the selections currently in the Analysis will be applied to that sheet (as bookmarks). Call this selection "A"

The "funny" behavior is that when you go back to Analysis view to make new selections (selection "B") for a different sheet you want to embed, the selections of the last page you viewed on Story will be applied (selection "A"). So when you go back to Story mode, and click on embed another sheet and select the new sheet, you would think selection "B" would be applied. Unfortunately the new embedded Sheet story will have selection "A" applied.

The workaround that I found:

Keep a blank page in Story mode, and click on that sheet before going back to Analysis mode. Make your new selections, go back to story mode and then add the new embedded sheet. You will now have a new Sheet in the story with the new selections. When you export the Story, each embedded sheet will have the selections when the Story sheet was created.

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Mon, 20 May 2019 13:34:41 GMT

Thanks QT for the reply. Neither of these scenarios apply. There is literally nothing going on in the selection criteria.

Here is the exact steps to we use to replicate the issue.

Close all browser sessions. Start completely clean. open a new browser session and go directly to the story with no navigation. Ensure no other browsers are open. Start on slide 1. Do not move off of slide 1. Export to Powerpoint. The KPI in the upper left that shows the maximum descriptor is not refreshing with the rest of the sheet. Everything else is refreshing appropriately. It appears to refresh every other sheet.

Close all browser sessions. Start completely clean. Open a new browser session and go directly to the story with no navigation. Ensure no other browsers are open. Start on slide 1. Navigate through each slide using your browser. The KPI in the upper left hand corner refreshes as appropriate. The story presents perfectly.

We have a ticket filed with Qlik as well. Should this potentially go under a new thread since this thread is marked as closed?

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Mon, 20 May 2019 13:51:01 GMT

Update: The export issues seem to exist exporting to both Powerpoint and PDFs in Chrome and I.E. 11. The export issue does not appear in Microsoft Edge. The KPI's change with the rest of the sheet when exporting from Microsoft Edge. This is only a temporary work around though as Chrome worked from mid Februrary 2019 to late April 2019.

Re: Story not keeping selections when exported to Powerpoint

Romstar111 — Tue, 18 Jun 2019 09:47:36 GMT

If this is a bug, it is till there because I have not able to export stories with the selection made in the story. I tried both Chrome and IE. I wonder where we are with the ticket as I could not see it in Qlik Support Portal.

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Tue, 18 Jun 2019 13:00:20 GMT

I did not get a good answer on my ticket and nothing was done with it. Support didn't think it was a bug but that this was the way the system worked. I had my VAR (value added Reseller) quoting documentation saying this should work the way we expect and did not get a response. That was May 28th. I have not had an update to the case since them. I am asking for an update today.

The problem is very specific to the KPI objects. They will repeat the value from the previous slide from time to time if you embed two live sheets with different filter selections back to back. There is not a pattern and it is not consistent. Interestingly text objects do not have this same bug. If you take a text object and build out the header and follow it with the formula from the KPI everything works properly every single time. It is the only relief I have been able to find for my users. In fact, we have created a version of the app with both KPIs and text box objects. When viewing the story in a web browser, both display the same data on every sheet. If you export the story, the Text boxes display the same data as displayed in the online web browser one very single slide and the KPIs only match the on screen version 50-60% of the time.

This behavior is exhibited in both PDF and powerpoint exports.

Re: Story not keeping selections when exported to Powerpoint

Jamie_Gregory — Wed, 26 Jun 2019 19:04:57 GMT

Hello @tim_ringle

This issue you reported regarding the KPI's and stories will be fixed in Qlik Sense September 2019. If you have any other questions, please let us know.

Re: Story not keeping selections when exported to Powerpoint

tim_ringle — Wed, 26 Jun 2019 19:30:14 GMT

Thanks,

I am very much looking forward to the release. I did get a note that this was forwarded to app dev, so I (and I am sure others), am glad to hear a permanent fix is on the way.

Thanks

Tim Ringle.