topic Re: NPrinting Issue in Qlik NPrinting

NPrinting Issue

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

Hi all,

While using the Nprinting, I have following questions to ask:

While dragging-and-dropping the image to NPrinting, the preview cannot show the whole table, how to settle the settings to print all the content in table?
How to rotate 90° of the image?
I have settled the conditional for showing colors. However, when I create the report in Nprinting, all the color settings disappears. Is it related to setting issues?

Regards,

Leo

Re: NPrinting Issue

Ruggero_Piccoli — Thu, 29 Aug 2019 13:05:24 GMT

Hi,

Please always specify the version of Qlik NPrinting you are using and the kind of report you are developing. Thanks.

1 The answer to this question depends on the version of Qlik NPrinting you are using and if you are importing from QlikView or Qlik Sense. The general suggestion is to keep your installation aligned to latest version.

2 It is not possible to rotate the image in Qlik NPrinting. Why do you need to rotate and image?

3 Are you exporting the object as image? Or as a table? If your condition depends on date did you checked the filters applied in Qlik NPrinting?

Best Regards,

Ruggero

Re: NPrinting Issue

kwoklimho — Fri, 30 Aug 2019 02:41:49 GMT

The version of Qlik Sense is 2019 April.

The version of Qlik NPrinting is 2019 April.

1. To clarify the first problem, please see the figure 1 and 2

figure1

figure2

Can I combine them into single page?

2. Since I want to combine the table into single page. Therefore, I need to rotate the image to save the space in order to adjust the image into single page.

3. I want to export the table in NPrinting. However ,the color conditions are not working

Regards,

Leo

Re: NPrinting Issue

Lech_Miszkiewicz — Fri, 30 Aug 2019 03:45:40 GMT

You have few ways of achieving this.

1. you dont need to rotate image to save space - how about changing page layout to horizontal of your template (which i only assume is Excel as you are not telling us this information)

2. use excel template, export data as a table and use excel formatting to apply conditional colours on your numbers

Re: NPrinting Issue

Frank_S — Fri, 30 Aug 2019 14:25:21 GMT

Hi @kwoklimho

Regarding your comment... "Can I combine them into single page?"

Starting in the September 2019 release of NPrinting, you will be able to export an entire Qlik Sense sheet to an NPrinting report.

Perhaps that version will meet your requirement entirely. A technical (test only, non production) preview release is now available if you would like to test and preview that functionality in a test environment exclusively. See link below regarding download and usage of Qlik NPrinting technical preview software.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Qlik-NPrinting-September-2019-Technical-Preview/td-p/1618311

Kind regards

Re: NPrinting Issue

kwoklimho — Wed, 04 Sep 2019 07:00:48 GMT

For point 1, could you guide me how to rotate the layout?

Re: NPrinting Issue

Lech_Miszkiewicz — Wed, 04 Sep 2019 07:02:10 GMT

Sure- what kind of template are you using?

Re: NPrinting Issue

kwoklimho — Wed, 04 Sep 2019 07:02:14 GMT

for point 1, could you guide me how to rotate the layout?

Re: NPrinting Issue

Lech_Miszkiewicz — Wed, 04 Sep 2019 07:08:14 GMT

https://support.office.com/en-us/article/video-use-landscape-and-portrait-in-the-same-document-ddd80cb6-c9ae-4493-ba75-c663074031a0

or simply

Re: NPrinting Issue

Lech_Miszkiewicz — Wed, 04 Sep 2019 07:16:27 GMT

For PixelPerfect template use properties to setup your report page settings

Re: NPrinting Issue

kwoklimho — Wed, 04 Sep 2019 07:35:23 GMT

Thanks for your help! Lech_Miszkiewicz, it works finally.

However, some rows and columns are missing in the report generated.

Are there any possible solutions?

Re: NPrinting Issue

Lech_Miszkiewicz — Wed, 04 Sep 2019 07:45:21 GMT

This is now whole new story. If your pivot table does not fit on full screen the image generated will be cropped (just like you have scrollbars in Qliksense). This is working as designed and there is nothing you can do.

What you can do instead is instead of using image you ca build your pivot table in excel or pixel perfect. This was already discussed and is very well documented in help (https://help.qlik.com) and community. Please search for it

Re: NPrinting Issue

Ruggero_Piccoli — Wed, 04 Sep 2019 08:47:24 GMT

Hi,

Please check the chapter Changing image size of Qlik Sense charts of the help site page https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/ReportsDevelopment/Image-Dimension-Management.htm

Best Regards,

Ruggero

Re: NPrinting Issue

Lech_Miszkiewicz — Wed, 04 Sep 2019 23:50:55 GMT

This is quite usefull.. I will have a play with this functionality as I was not fully aware of its existence. Will be probably usefull to see how it works with screenshots attached for comparison ...

Re: NPrinting Issue

Lech_Miszkiewicz — Thu, 05 Sep 2019 01:20:55 GMT

I did some initial testing... and it turned out it is actually possible just like Ruggero said to change Qlik Sense object size to show more data if required. This was introduced in NPrinting February 2019 and i simply missed this feature!

now down to my testing...

I created very wide pivot table and set the ata Displayed Width (px) and Data Displayed Height (px) to 3000 px and 270px.

This has created an image indeed wide as per my request. I noticed however that my image is not wide enough to show full pivot table as i had more column data still in it.

I then increased Displayed Width (px) to 4550px and generated report again. It created the requested image, contained all data i needed but image became blury. (see comparison below of those 2 images or maybe better just download attached excel to see what i mean).

@Ruggero_Piccoli is there a known max value for those parameters? I am also submitting a support case (01713559) regarding this to either include max parameters in documentation or consider it as a bug.

Re: NPrinting Issue

Ruggero_Piccoli — Mon, 09 Sep 2019 10:25:06 GMT

Hi @Lech_Miszkiewicz ,

I confirm that colleagues are working on the issue. Of course, I don't have any estimated time of the resolution or technical details.

Best Regards,

Ruggero

Re: NPrinting Issue

Lech_Miszkiewicz — Mon, 09 Sep 2019 23:26:04 GMT

no worries mate, thanks for checking this out!