topic Re: NPRITING with filters in Qlik NPrinting

NPRITING with filters

QS21 — Thu, 14 Jul 2022 04:00:52 GMT

Hi all,

I have a table chart in my qliksense app and various filters.

I need to export this table chart in to PPT or PDF into different slides with different filters selected. How is this possible in NPrinting?

Thank you!

Re: NPRITING with filters

Ruggero_Piccoli — Thu, 14 Jul 2022 07:32:41 GMT

Hi,

What you are asking is documented in the help site. If you are new to Qlik NPrinting I suggest you to start from https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/Introduction/Get-started.htm

Creating PowerPoint reports is explained in details at https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PowerPointReports/Intro-PowerPoint.htm and they can be exported also in PDF. There are other types of templates that can be exported as PDF and they are listed in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DistributionSchedulesAutomation/Report-output-formats.htm. If your main goal is to generate PDFs I suggest to start from a PixelPerfect template. It requires a longer development time but it lets you to set details at a very fine level. They are explained in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/PixelPerfectReports/Intro-PixelPerfect-Reports.htm

In you want to create a slide in a PowerPoint template for each distinct value of a field you can add it in the Pages node. The Pages node also supports straight tables, in that case you will have a different slide for each row of the added table. Each slide will be filtered by the value that generates it.

Best Regards,

Ruggero

Re: NPRITING with filters

QS21 — Thu, 14 Jul 2022 07:43:07 GMT

will surely try that, Thank you!

Re: NPRITING with filters

Saurabh_K14999 — Thu, 21 Jul 2022 10:52:23 GMT

Hi,

For this you need to first create all the filters which you require in the N Printing

After that you need to add the same table multiple times as many as filters you have

Then apply each require filter to each table in different sheets in the filters options.

Best Regards,

Saurabh.

Re: NPRITING with filters

QS21 — Thu, 21 Jul 2022 11:48:26 GMT

Thanks Saurabh, I did try this now te issue is my table has around some 30 rows or so. when I try to use PPt format, and applying the image object of table, it is fitting all the columns but is missing out some bottom rows, even if I put only this object for entire slide it is like that only. How to increase the height of the image object in PPT NPrinting? any idea?

Re: NPRITING with filters

Ruggero_Piccoli — Thu, 21 Jul 2022 13:06:51 GMT

Hi,

Did you already give a check at the page https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Image-Dimension-Management.htm?

Best Regards,

Ruggero

Re: NPRITING with filters

Frank_S — Thu, 21 Jul 2022 16:40:01 GMT

@QS21

Powerpoint reports are limited to only what is in the visible space of the first PPTX slide.

Additional rows do not auto extend to the next slide unfortunately as this is a Microsoft Limitation and as such there is no possibility to enable this from the NPrinting side.

Overflow rows will not appear when using the 'presentation' mode. Only rows in the 'printable' area of the slide will appear.

Suggest that you use Pixel Perfect or MS word report editors to build your report if you need to see all rows in your report output.

Kind regards...

Re: NPRITING with filters

Digvijay_Singh — Thu, 21 Jul 2022 17:04:53 GMT

If you got just a table in your slide with 30 rows with not big labels, I think you can fit that in one slide, try to drag individual columns and reduce font size. I think with some manual formatting, you can manage to fit that in one slide. But yeah if you got other charts and if some of the columns got long text, it will be a challenge.

Few times I added table as an image and used the bottom left properties to shrink the chart by adding resolution in pixel, that helped sometimes.