graph with two dimensions and one metric

[lpenya31]

Hello

I want to create a graph in the power point report that tells me the volume of sales that have been generated in the last three years by each sales team, or by each area of the country, or by product.

I can't find any documentation that tells me how to create these graphics.

[joaopaulo_delco]

Hi @lpenya31 !

    First of all you need to build a project with this graphs. You can learn how to do it in https://learning.qlik.com/.

You'll find are a bunch of free videos about it.

After build this project, you have to put this graphs in the NPrinting power point report.

[Lech_Miszkiewicz]

Hi @lpenya31 

Have you gone through NPrinitng training? and are you experienced Qlik developer? Those 2 should be first prerequisits before you start work with NPrinting. If you want to self train start from https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/Examples/Examples.htm to get sample files and follow steps to:

create NPrinitng App: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/GettingStarted/Your-First-Web-A...
create connection: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/GettingStarted/HowCreateConnect...
create PPT report: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/PowerPointReports/Intro-PowerPo...
and little bit advanced option to create native PPT charts: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/PowerPointReports/Chart-Native-...
Then depending on how you want use your reports you may need to consider using:

Page tag in PPT repors: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/PowerPointReports/Pages-individ...
Cycle report: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Cycling-your...
Use filters: learn differences of using different types of filters: https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Static-dynam...
All is well documented in https://help.qlik.com and I rather suggest that as starting point as you get a lot more detailed info than from  https://learning.qlik.com/. On Help site there are also videos....

I hope this and info from @joaopaulo_delco will help you start...

cheers

[Lech_Miszkiewicz]

Hi @lpenya31 

I have also another idea. Before we start talking about NPrinitng can you attach PPT file with sample of what you are trying to do? That will help us understand if at least what you have imagined is possible at all...

cheers

[lpenya31]

Hi @Lech_Miszkiewicz . 

Thanks for your answers . I have already completed the training you send me.

I specifically want to (create o generate) graphs in a report where I can see the volume of sales in a given period and classified by product, by country, or by another criteria.

I send you an example. 

[Lech_Miszkiewicz · Accepted solution]

First of all you need create a data for your chart. This should be done in Qlik Sense table. With PowerPoint chart there is that limitation that you need to have each category as separate data series. With that in mind you must prepare table where you will have dimension (date or month year or whatever you used as X axis dimension) and then for each category you must create a measure using set analysis in expression.

Rest is just basic:

• Open Template
• Add Table object which will be source for your chart to entity tags on left
• Insert Chart->>pick line chart
• Drag&drop tags from previously added table to excel template (exel template opens when you try to add data to your power point chart)
• thats it.

Limitation:

• it will be hard to get dynamic number of categories in this chart as each category needs to be expression with separate set analysis
• I can see option where this can be semi-dynamic... but you will have to aim for limited number of categories (say up to 10 or 20 ro whatever....) and create as many expressions as required with more dynamic sets based on IndexValue

Let me know if all is clear? Or which bit you dont understand.

Obviously as always most of development and preperation needs to be done on Qlik Sense side and NPrinitng should be fairly simple.

[Lech_Miszkiewicz]

or as a alternative create line chart directly in Qlik Sense and then use image tag to display it in PPT. It will look a lot worse but it will be easier to start.

Period selection should be handled by applying a NPrinitng filter.

You may want to share steps you are taking so we can understand we step you struggle with or where you go wrong otherwise it will be hard to help you more.

[lpenya31]

@Lech_Miszkiewicz 

Your explanation is perfect ... !!

Your answer is very aligned with what I thought at a time that I will have to do, in my case the dimensions that I have to graph are infinite and are adapted according to the client, so I will have to shorten as you say to a maximum of 10 per graph.

At the image level I tried but visually it does not look very good.