topic Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart in Qlik NPrinting

Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Wed, 06 Dec 2017 18:50:30 GMT

Hello,

I have a PowerPoint report that is generating a list of different product lines under different business segments. In the qlik sense app, I have color codes based on segment, so the bar charts display different colors based on those segments. For instance, green for shoes - red for shirts etc...

When I generate my native PPT charts via table nodes, I do not get my custom colors on the PPT charts. Is there a way to put the colors into the expression box or somewhere else (PPT maybe?) so they come through into the table object formula?

Thanks!

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Fri, 08 Dec 2017 18:23:59 GMT

Any thoughts anyone?

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Lech_Miszkiewicz — Fri, 08 Dec 2017 22:45:19 GMT

I think you should ask this question in Microsoft PowerPoint forum:

Results in Office - Microsoft Community

this is solution for excel - i assume similar may be possible for PPT as it uses Excel as a starting point for chart creation..

https://www.extendoffice.com/documents/excel/2343-excel-change-chart-color-based-on-value.html

regards

Lech

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Fri, 08 Dec 2017 23:39:07 GMT

I will look into this! Thank you for sharing Lech.

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Lech_Miszkiewicz — Fri, 08 Dec 2017 23:48:17 GMT

I gave it another thought and you may struggle with this as PowerPoint Charts are limited as oppposed to Excel Charts.

Worth exploring though.

good luck

I may give it a go as well later (once i have enough time to build a template to play with)

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Fri, 08 Dec 2017 23:49:55 GMT

Thanks Lech, you are super nice.

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Lech_Miszkiewicz — Mon, 11 Dec 2017 12:09:47 GMT

Hi Russell,

I did a go with Power Point but i was not even able to achieve manually what you are trying to do automaticly.

i may get a chance trying later and resarching, but for now i have given up - sorry mate.

regards

Lech

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Mon, 11 Dec 2017 12:41:05 GMT

Thanks Lech,

I wonder, can they be built in excel and moved over to a PPT? Did you say you were able to do it in excel?

Thanks,

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Lech_Miszkiewicz — Mon, 11 Dec 2017 21:12:13 GMT

I have sent you previously link to how this is achieved in Excel. This however is not dynamic solution and you need to know how many attributes you will have as for each attribute you need to create dedicated measure.

This would be very static solution though!

cheers

Lech

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Ruggero_Piccoli — Tue, 12 Dec 2017 14:13:57 GMT

Hi,

I created the attached example by using Qlik NPrinting November 2017. I followed the Office tutorials linked by lech_miszkiewicz‌ and I created a very simple QVW:

Create a connectio to the .qvw and generate its cache. There is a single table object with 3 data series, one for each color.
Create a PowerPoint report
Add a native chart to the PowerPoint report by following Creating a PowerPoint chart using native QlikView tables ‒ Qlik NPrinting.
1. Add the TB01 into the Tables node of the template
2. Add a chart
3. Drag and drop each single column into the Excel sheet that contains data for the chart
4. Set the data origin to met you requirements
Run a report preview
Change the chart options as you prefer

In the attachment there is also the report that can be imported if you are using November 2017.

Let me know if this solves.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. 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: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Tue, 12 Dec 2017 15:45:58 GMT

Hi Ruggero,

Thanks for your reply. I am actually working in Qlik Sense, so I cannot open a .QVW. Can you explain how to work in the edit data area of the native PowerPoint chart? Maybe attach some images? I am struggling with the nodes and how that would all work to automatically get the colors through to the native table.

Thanks,

Re: Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart

Anonymous — Thu, 14 Dec 2017 19:53:22 GMT

Just an update, I was able to add 3 nodes on three columns next to my dimension column and color code each column to be the right color. Now I just need to figure out how the report would generate a zero or blank cell in the columns that are not the correct color for the particular product line in the excel.

Any thoughts?