topic Re: Add Excel objects in Reporting Service & Alerting

Add Excel objects

John-SSI — Fri, 15 Nov 2024 21:10:10 GMT

Hi all,

Is there a possibility to add a piechart in the excel-template that then can show the data in the report?

The data in the report can be more and less rows from day to day.
Or should i build an table that's is calculated.

The data from Qlik is:

ServiceArea	Cause1	AllWo
4	Control	1
7	Control	1
3	Electrical	1
4	Electrical	1
1	IT/WAMAS	1
2	IT/WAMAS	2
1	Mechanical	2
2	Mechanical	4
4	Mechanical	1
5	Mechanical	14
10	Mechanical	3
4	Product	2
5	Product	1
1	Unit Load	2
4	Unit Load	1
1	-	4
2	-	2
5	-	3

And if i use chartguide in Excel it transforn to this:

And the result is this:

Is this possible?

Re: Add Excel objects

Anil_Babu_Samineni — Wed, 10 Jan 2024 14:27:17 GMT

@John-SSI If that is Donut and pie chart, we can do. If you look the orientation in the same way how you want. It is not that flexible with native just yet in on-premise.

Re: Add Excel objects

Lech_Miszkiewicz — Thu, 11 Jan 2024 00:43:46 GMT

Hi @John-SSI

The best way to achieve this would be to create a table in Qlik Sense with data aggregated to the level you require in your pie chart and then use that table data in sheet and add the chart based on it.

Yes - you could use pivot chart functionality too, but I am not a fan of it.

Re: Add Excel objects

John-SSI — Thu, 11 Jan 2024 07:03:01 GMT

Yeah, great. I will try. And if the data have more or less rows from day to day , the reporttemplate can handle this?

Re: Add Excel objects

John-SSI — Thu, 11 Jan 2024 07:35:19 GMT

Hm, the Excel reports seems not to support pivot from Qlik Sense.

It looks that im getting the data in a straight table then put it in to the report, then build a pivot in excel, the create a piechart

Re: Add Excel objects

Lech_Miszkiewicz — Thu, 11 Jan 2024 07:46:58 GMT

Well yeah - I was talking about a straight table as that is the best option (similar as in with NPrinting) and if you aggregate data in Qlik Sense to the required level you dont need to do pivot table in Excel, and instead you can build your chat straight off the straight table.

Re: Add Excel objects

John-SSI — Thu, 11 Jan 2024 08:15:29 GMT

Dosent work 😞
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Tabular-Reporting-the-table-Individual-column-option-can-t/ta-p/2152412

Re: Add Excel objects

Lech_Miszkiewicz — Thu, 11 Jan 2024 08:34:54 GMT

Hi @John-SSI

I said that I would create Qlik Sense straight table object for use with individual columns. Link you have provided is related to following objects only:

BoxPlot,
Distribution plot,
Histogram,
AutoChart,
Objects containing Calculated columns.

Re: Add Excel objects

Andrew_Kruger — Thu, 11 Jan 2024 15:04:11 GMT

I think you are trying to do something like this

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-native-tables.htm

but with a native excel chart.

If you follow the initial steps here (but use a pie chart) it should work. Please note the recommended practice is to have the Qlik sourced straight table in a sheet (likely hidden sheet or maybe at the end of your workbook) and have the native object in a different sheet.

thanks @Lech_Miszkiewicz for guiding this post

Re: Add Excel objects

John-SSI — Thu, 11 Jan 2024 18:16:25 GMT

Working, thanx 🙂

Re: Add Excel objects

John-SSI — Sun, 14 Jan 2024 08:34:58 GMT

Hmm, next question, i can get i right.

When i try to create a Excel chart i only take the first values.
Is there a trick to get this right?

Br
John

Re: Add Excel objects

Lech_Miszkiewicz — Sun, 14 Jan 2024 23:18:37 GMT

Hi @John-SSI ,

I normally use Excel Table and reference table in chart. Also I add 1 extra row under data <tags> and I put in that extra row <deleterow> tag to remove it later.

cheers