topic Re: Pivot table in NPrinting format ppt. in Qlik NPrinting

Pivot table in NPrinting format ppt.

Anonymous — Tue, 13 Feb 2018 18:05:59 GMT

Hello, I am working on the NPrinting version November 2017. In a project in qlik sense we have a pivoting table and I need to send weekly reports through NPrinitng.

I have managed the option of exporting a dynamic image of the table, but when submitting the presentation the blank design of the table does not match the rest of the sheet

Is there a power point option to display the pivot table and edit the design other than through the photo?

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Wed, 14 Feb 2018 08:36:24 GMT

Hi,

In PowerPoint reports you can import Sense pivot tables only as images, but you can change the images dimensions https://help.qlik.com/en-US/nprinting/November2017/Content/ReportsDevelopment/ImageDimensionManagementMicrosoftOfficeRep…

In Excel templates you can create native pivot tables:

- https://help.qlik.com/en-US/nprinting/November2017/Content/ExcelReports/HowCreateExcelPivotTableReport/Excel-pivot-table-report.htm

- https://help.qlik.com/en-US/nprinting/November2017/Content/ExcelReports/HowCreatePivotTableExcelTableColumns/Pivot-table…

but this is not supported in PowerPoint reports.

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: Pivot table in NPrinting format ppt.

Anonymous — Thu, 15 Feb 2018 15:00:04 GMT

Hello Ruggero,

Thanks for your answer.

They told me that there is the possibility of using the HTML and css format in NPrinitng to visualize the pivot tables.

There is a documentation that helps me to develop it.

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Fri, 16 Feb 2018 08:32:00 GMT

Hi Felipe,

About the documentation, please refer to the official help site https://help.qlik.com/en-US/nprinting/February2018/Content/Introduction/Introduction.htm. Use always the helpsite with the same version of your installed Qlik NPrinting.

HTML reports are supported https://help.qlik.com/en-US/nprinting/February2018/Content/HTMLReports/IntroHTML.htm and you can insert pivot tables into them as Images.

Best Regards,

Ruggero

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

Re: Pivot table in NPrinting format ppt.

Anonymous — Mon, 19 Feb 2018 21:01:22 GMT

Hello Ruggero, after many tests I finally decided to use images. The problem now is that when extracting the image of a pivot table for power point it does not show all the fields and I have not found the option to solve it.

I use the November version of NPrinting.

Greetings.

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Tue, 20 Feb 2018 09:11:14 GMT

Hi,

You see the scroll bars that are fixed in the image. Try to enlarge the original image in Qlik Sense.

Best Regards,

Ruggero

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

Re: Pivot table in NPrinting format ppt.

rfredman — Fri, 25 May 2018 11:13:09 GMT

But is it possible to shrink the resulting image in ppt/pixelperfect reports?

I get the whole pivot table as a picture but it doesnt fit on the ppt/pixelperfect page area.

I can resize the page to A2 and it will fit but the business doesnt like it when the reports come in that format, the prefer it as standard A4....

/Rickard

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Thu, 31 May 2018 08:49:41 GMT

Hi,

Give a check at the page https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Image-Dimension-Management.htm.

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: Pivot table in NPrinting format ppt.

rfredman — Wed, 27 Jun 2018 14:18:28 GMT

That doesnt work. It doesnt shrink the image of the pivot.

I have tested it with other objects and those are being resized correctly.

(On april2018 release)

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Tue, 03 Jul 2018 14:35:43 GMT

Hi,

I did the attached report with April 2018.

Best Regards,

Ruggero

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

Re: Pivot table in NPrinting format ppt.

rfredman — Tue, 31 Jul 2018 07:22:38 GMT

But if you try to make the "fit inside" image even smaller, it wont shrink the image, it will instead start cutting of parts of the image.

Nprinting tries to fit the image by resizing column, it doesnt shrink the image.

Is it not possible to actually shrink the image so that we can fit large tables on a page?

See attached file.

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Tue, 31 Jul 2018 07:52:54 GMT

Hi,

Fit Inside (default setting): Image height and width remain the same, or the height and width are reduced proportionally until both are smaller than the settings in the template. Image quality is not degraded.

Based on what I knwo we don't have bug on this.

Your picture seems related to:

Fit Width: Image width remains the same, or changes to the width set in the template, whichever is smaller. Image height is adjusted proportionally.

From https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Image-Dimension-Management.htm

You need to set Fit Inside in the Properties window of the specific image.

If this doesn't work send a support case with attached the source app and the template so we can investigate directly.

Best Regards,

Ruggero

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

Re: Pivot table in NPrinting format ppt.

rfredman — Tue, 31 Jul 2018 09:23:28 GMT

Ok, will have our guys create a support case with you.

(I am using fit inside on the image, not fit width).

But please, try yourself to make your image much smaller, i bet it wont shrink...

/Rickard

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Tue, 31 Jul 2018 09:28:10 GMT

I tried and I shared the result here in a previous post. In my exaple Fit Inside is working as expected so I'm not able to reproduce the issue. This is the reason why I suggested to open a support case with the template and the source app attached. I hope that we will be able to reproduce the issue here.

Best Regards,

Ruggero

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

Re: Pivot table in NPrinting format ppt.

rfredman — Tue, 31 Jul 2018 12:55:25 GMT

It is that example that i'm referring to. If you look at your Fit Inside example you see that nprinting haven't shrunk the image, it has instead made the column widths smaller so that the table fits inside.

If you would have made the image even smaller, so that nprinting cant shrink the columns enough to fit, it would then cut off the columns that doesnt fit instead of shrinking the image.

The Fit Width example in your file doesn't work as expected either

Fit Width: Image width remains the same, or changes to the width set in the template, whichever is smaller. Image height is adjusted proportionally.

It has just cut of all the year columns to fit width, instead of actually fitting the width by shrinking it.

I will create an example and sent it to your support, will update with the response here...

Just FYI, converting old qlikview nprinting reports to qliksense reports with the new web based nprinting havent been fun to put it mildly. It is a constant stream of irritating bugs and stuff that doesnt work. (for example, there is no option to abort a report preview from the template editor!...)

/Rickard

Re: Pivot table in NPrinting format ppt.

Ruggero_Piccoli — Thu, 02 Aug 2018 13:21:01 GMT

Hi,

You can abort a report preview starting from June 2018. From its release notes:

Continue to update a template in Qlik NPrinting Designer when previewing

Report preview is now executed in a separate thread, so the user can continue to edit the report

template while report preview is generating. The new "Preview" group in the ribbon menu now has a

progress bar.

The new Abort button lets the user stop report preview generation. If preview generation takes more

than 2 hours, it will timeout.

After updating to latest version, if you still have issue, please open a different conversation for each issue, or send a support ticket. We will investigate if there are bugs or we will help you to reach your goals.

Best Regards,

Ruggero

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