topic Re: Powerpoint KPI formatting in Qlik NPrinting

Powerpoint KPI formatting

nvrphanikumar — Wed, 25 Sep 2019 18:40:54 GMT

Fairly new to Nprint.

Would like to call out KPI's in a powepoint.

When i import prebuilt kpi's as images,i'm unable to embed them between sentence's and well format them within Nprint.

Tried to use KPI's as Formulas in Designer and embed them into power point but unable to format them

I noticed PDF has better formatting options.Is there a better way to Properly call out KPI's in powepoint ?

Re: Powerpoint KPI formatting

Frank_S — Thu, 12 Sep 2019 15:43:38 GMT

Hi @nvrphanikumar

Welcome to Qlik NPrinting and the NPrinting Community.

First, just a few points:

It would be useful/helpful to know which Qlik Platform you are connecting to including version number. QV?QS? version?
Exactly what your requirement is? What have you tried so far? Can you show your work here by uploading images of
Expected results (mockup if needed)
Actual results you seeing.
Have you viewed any training videos regarding NPrinting? These are extremely well done videos that will provide a lot of design tips and tricks. Click NPrinting once you open the following link https://help.qlik.com/en-US/videos
Have you receive any formal Qlik NPrinting training thus far? http://inter.viewcentral.com/events/cust/default.aspx?cid=qlik&pid=1&lid=1
Keep in mind also that there are limitations when using certain KPI's with NPrinting with Qlik Sense. https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/create-visualization-extensions.htm

Also the NPrinting online help is an important resource as well for newcomers to NPrinting.

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/Introduction/Introduction.htm

Hopefully this information guides you in the right direction and that you enjoy your experience with Qlik NPrinting. The videos and help links mentioned here may also give the answers you are looking for.

If you can provide any additional information mentioned above, the members of this community may be able to further point you in the right direction.

Kind regards...

Re: Powerpoint KPI formatting

nvrphanikumar — Thu, 12 Sep 2019 16:22:11 GMT

Thanks Frank.

Nprint Version: 19.19.4.0 ;

Qlik sense is Nov 2018 Patch 4( 12.44.7)

Users would a Power Point Output designed using Nprint.

I displayed the layout in the picture.

I tried to display the % using Formula's but unable to format them.

When I use Images,I'm unable to size them as mentioned in the layout.

Tried importing them as tables ,didnt help either.

I will checkout your other links.Thank you

I haven't gone through an official training for designer but have gone through the youtube videos .

Re: Powerpoint KPI formatting

Frank_S — Thu, 12 Sep 2019 22:13:21 GMT

Hi @nvrphanikumar

I did some testing and confirm that you cannot format formula values.

To do sums and other chart value type formulas I suggest that you:

1. Create a Chart in qlik sense that contains the values you want to export in your NP report
2. Reload your NP connection to see the new chart
3. Add the chart field to the template
4. Remove 'keep source formats'
5. Add your format to the format field after removing keep source format ie $#,##0.00
6. Preview your report...see about below.

Hope this clarifies and guides you in the right direction!

Kind regards...

Re: Powerpoint KPI formatting

Lech_Miszkiewicz — Fri, 13 Sep 2019 01:18:38 GMT

For the KPI in PPT you can still format values directly in formula using num() function

like:

num(Sum(Expression1),'#,##0.0 %')

....

Re: Powerpoint KPI formatting

nvrphanikumar — Fri, 13 Sep 2019 13:39:02 GMT

Thanks.This certainly helped.

I was focused on getting to format it using power point .

I was able to apply your suggestion and then able to increase size and change colors in Powerpoint.