NPrinting June 2018 / Qlik Sense : how to get a good quality and complete image of a wide and long Pivot?

[Anonymous]

Hello Everybody!

I am struggling with a Pivot in Qlik Sense that I want to use as an image in my Nprinting Report. My client wants the distributed Report to have exactly the same look and feel as the Qlik Sense App.

It is a wide (14 columns) and quite long (30 lines) Pivot and when I want to use it as an image in NPrinting it is not only incomplete (around 6 lines missing) but also in a very bad quality, even if I chose the option "Very High Quality".

Is tested all possible options but couldn't solve this.

Is there a way to have a good quality and complete image of such a table or am I just asking too much?

Thanks a lot for your help!

Kind regards,

Stella

[Ruggero_Piccoli]

Hi,

In this case I would to suggest to create a straight table with the necessary columns and use it to create an Excel native pivot table. Then you can use Excel formatting features to reach the format you want.

If the original object has scroll bars it will be exported with them but it is an image so they will not work. You could also try to enlarge the original object.

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.

[Anonymous]

Hi Ruggero,

Thanks you. Yes...I will have no other choice. But it is a lot more work. My client expected a drag and drop solution...Now, the objects need to be duplicated, transformed, exported and the complet Pivot has to be rebuilt in Excel and the Formats/Colors to be redefined. And there are a lot of objects.

Kind regards,

Stella

[Ruggero_Piccoli]

Hi,

You can also add the original pivot table in the Excel template Tables node and drag and drop it into the template. It will be exported as is in the Qlik Sense app.

Faster but less control on the final result.

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.

[ramsurya]

Hi Ruggero,

Can we add excel template table node in Pixcel perfect reports in nPrinting 16.
If yes can you please provide me steps for how to create. If possible can you please attach sample file as well.

Thanks in advance.