topic Re: PowerPoint Combo charts reset data range in Qlik NPrinting

PowerPoint Combo charts reset data range

Sergey241 — Fri, 28 Jan 2022 10:46:39 GMT

Hello.

In PowerPoint, when I assemble (Preview) the presentation, combo charts have their data range reset and the data doesn't have the formatting that I set in Excel.
Turn off the "Keep Source Formats" checkbox.
In the designer, the table is displayed correctly, formatting is applied, and the calculated field is displayed.
I am attaching screenshots.

Nprinting version - Qlik NPrinting April 2020 Version: 20.10.2.0

Qlik Sense version - Qlik Sense November 2020 - 13.102.5

I will be glad for any help.
Thank you.

Re: PowerPoint Combo charts reset data range

Ruggero_Piccoli — Fri, 28 Jan 2022 13:46:55 GMT

Hi,

Thanks for the screenshots. I'm sorry but I have not completely understood your question. You are trying to create a native PowerPoint chart from Qlik Sense data and, in the resulting report, some columns are missing, correct?

If this is the scenario please check https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/PowerPointReports/Chart-Native-Tables.htm that you are working on a supported type of chart.

Are you trying to embed an Excel worksheet in a PowerPoint template?

Best Regards,

Ruggero

Re: PowerPoint Combo charts reset data range

Frank_S — Fri, 28 Jan 2022 22:54:31 GMT

Hi @Sergey241

I've created a Powerpoint Chart with Qlik Sense data and did not have to uncheck 'keep source formats'. (the steps as mentioned in the link above from @Ruggero_Piccoli

I will attach a sample report that I created along with source QVF file and sample output. (see attached zip file MS Chart with QS data.zip below.)

I also did not understand exactly what the issue you have experienced, but I presume that your expected certain results that did not appear until you 'unchecked' keep source formats in the NP template editor

In my example, I did not need to take that action and I was able to produce a chart with two calculated columns and one dimension (to parallel your QS app).

Kind regards.

Re: PowerPoint Combo charts reset data range

Sergey241 — Wed, 02 Feb 2022 11:37:27 GMT

Hello. Sorry for the long answer.
Thank you for your responses.
I'm trying to display QS data in a combo chart and calculate the additional field "Amount for the year - YTD in it.
In the template editor, the "YTD" field is displayed, but when I click "Preview", the data is substituted into the chart, and the additional field is not displayed.
I'm building a chart using the powerpoint function "Change data in Excel". In the final presentation, if I change the data for the chart using excel, the "YTD" field is shown, but it is not reflected in the diagram and must be added manually.
Thank you

Re: PowerPoint Combo charts reset data range

Frank_S — Thu, 03 Feb 2022 23:25:20 GMT

@Sergey241

In a previous comment, I created and shared an app and report with you so you could reverse engineer how to create such a report successfully.

If that doesn't help you, I suggest that you add:

Detailed steps you are taking to create the report
Include snapshots of each step.
provide a mock up image of the expected results
provide and image again of the actual results
describe in detail what you mean by " if I change the data for the chart using excel, the "YTD" field is shown, but it is not reflected in the diagram and must be added manually"

If we are going to be able to provide some kind of meaningful response, well need this level of detail provided from.

However again, if you check my app and report to try reverse engineer it, you might see where to solve the problem (whatever that is since it is still unclear to us) in your environment.

Otherwise, it may be prudent for to work with your Qlik Account manager who can arrange a consulting engagement to help you with your requirement and perhaps other reporting requirements if we are unable to help you here in this forum.

Kind regards