topic Re: Create a stacked bar chart with PowerPoint Object in Qlik NPrinting

Create a stacked bar chart with PowerPoint Object

_jespers_ — Thu, 04 Oct 2018 07:31:13 GMT

I'm trying to create a stacked bar chart with a native PowerPoint object by using the edit data feature, but I have an issue trying to understand how to place the tags.

I have two dimensions:

- Year Month

- Attribute

I have one measure:

- Amount

How do I need to arrange these tags to be able to get a stacked bar chart?

Re: Create a stacked bar chart with PowerPoint Object

Ruggero_Piccoli — Thu, 04 Oct 2018 10:53:12 GMT

Hi,

You have to place the column tags as in the following screenshot:

Of course, first you have to create the columns, maybe by using set analysis.

The result will be like the following:

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Create a stacked bar chart with PowerPoint Object

_jespers_ — Thu, 04 Oct 2018 11:47:22 GMT

Thank you for you answer, but there must be some other way this can be done?

The dimension Attribute has a dynamically amount of elements depening on which user that gets the report, and also there is way too many elements to generate this manually by creating each column by set analysis.

And FYI, in my example I want the x-axis to be Year Month-dimension and the stacked values should be the Attribute-dimension

Re: Create a stacked bar chart with PowerPoint Object

Ruggero_Piccoli — Thu, 04 Oct 2018 12:09:57 GMT

Hi,

The number of columns is fixed and you set it during the report creation. The number of rows is dynamic in the meaning the Qlik NPrinting will include the correct number of rows during the report production.

Best Regards,

Ruggero

---------------------------------------------