topic Re: Resize Image of a Pivot Table in Word? in Qlik NPrinting

Resize Image of a Pivot Table in Word?

swiss49_ag — Tue, 10 Apr 2018 09:58:06 GMT

Dear All

I'm running QlikSense in combination with nPrinting (Feb2018 Release).

In my Sense App I have a Pivot Table which I need to display in a Word Report using nPrinting.

Image Resizing Options:

If I try to "Fit inside" or "Stretch" (using the Properties Window of nPrinting designer) - The Pivot Table gets cropped. So not all Data is being displayed.
The only option to see all relevant data would be the setting "Don't Fit" - but with this setting it will result in the picture to be way to big for my document... just overlapping the document.

I'm unable to resize this Image to fit my Word-Document Template and display all data at the same time. After hours of searching I start to get the feeling, this i not possible with nPrinting.

Is there any valuable feedback about this behaiour out there?

Best - Matthias

Re: Resize Image of a Pivot Table in Word?

Lech_Miszkiewicz — Wed, 11 Apr 2018 05:31:38 GMT

Hi Matthias,

Can you please explain how many columns you have in your pivot view and if there is a way of using straight table instead with set analysis etc?

It really depends on how often values in your dimension providing column values change.

regards

Lech

Re: Resize Image of a Pivot Table in Word?

swiss49_ag — Wed, 11 Apr 2018 12:37:23 GMT

Dear Lech

In my Example I would like to see the Header plus 12 Columns for each month. Basically there would be enough space to make the columns smaller - but I'm unable to control this.

So in my case - the Pic gets cut off in the November Column. (see below)

At the end, my question is generic, I'd like to have the opportunity to resize and make the Charts/Tables/Graphs to fit into the place in Word - even if they get a bit smaller at the end. It's much more important do see all data than having a chart being cut off.

regards Matthias

Re: Resize Image of a Pivot Table in Word?

Lech_Miszkiewicz — Thu, 12 Apr 2018 08:36:11 GMT

Well this is a good news

You then build straight table with 12 expressions (each for each month)

something like:

Count({<Month={'Jan'}>} Flight)

Count({<Month={'Feb'}>} Flight)

Count({<Month={'Mar'}>} Flight)

etc for the rest of month

Expressions will maybe be more complex to handle also year selection but it is all doable.

Once you have straight table you can create pixel perfect native table and you can format it as you wish:

Creating a native PixelPerfect table - Qlik NPrinting - YouTube

cheers

Lech

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

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: Resize Image of a Pivot Table in Word?

Ruggero_Piccoli — Thu, 12 Apr 2018 13:12:00 GMT

Hi,

With a straight table instead of a pivot, you can also create a native Word table so you don't need to migrade the report from Word to PixelPerfect.

Do the following:

create the straight table
refresh the Qlik NPrinting connection cache
add the new table in the Tables node of the Word template
expand the node by clicking on the plus simbol
select the columns you want to have in the report (use shift or ctrl for multiple selection)
crag and drop the columns into the template
a native Word table will be automatically created

Best Regards,

Ruggero

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

Re: Resize Image of a Pivot Table in Word?

Lech_Miszkiewicz — Fri, 13 Apr 2018 01:05:29 GMT

My bad - i had the same question for Pixel Perfect reports and got fixated (mixed topics)

My apologies!

Yes - you can do the same in Word using word in built tables

regards

Lech

Re: Resize Image of a Pivot Table in Word?

swiss49_ag — Tue, 17 Apr 2018 13:04:21 GMT

Hi Lech

Thanks for your answer!
I actually would like to keep this dynamic - so the Report may be rendered for a Quarter / Month / Year. Just depending on the Customers needs.

The Pivot Table will not be available as "Table" to select in nPrinting.

I'll keep searching...

brgds Matthias

Re: Resize Image of a Pivot Table in Word?

swiss49_ag — Tue, 17 Apr 2018 13:10:04 GMT

Dear Ruggero

This is actually my issue - cause I'd like to keep the report dynamic. So I can't do this with a static/straight table.

Still thinking about it...

Thanks anyways

Matthias

Re: Resize Image of a Pivot Table in Word?

Lech_Miszkiewicz — Tue, 17 Apr 2018 23:26:05 GMT

There is nothing to search - You only have 2 options:

if you want to use pivot table out of the box it needs to be image
if you want any other object to mimic pivot table you only can use straight table with logics (set analysis) on each expression. This still can be dynymic as long as the main dimension stays the same (like: month, day, quarter... whatever...)
- this solution still allows you to create dynamic labels for each column header
- the benefit (or maybe drawback) is that report template has to be ready for X number of columns to be produced in report. Those columns may/,may not be filled up with values, but they will be there. I think this is still the most elegant solution for your requirement.

regards

Lech

Re: Resize Image of a Pivot Table in Word?

swiss49_ag — Mon, 30 Apr 2018 13:04:04 GMT

Hi Lech

That's probably the best possible answer - however not really the feature what I was hoping to find out about.

Re: Resize Image of a Pivot Table in Word?

Lech_Miszkiewicz — Mon, 30 Apr 2018 23:10:21 GMT

Hi Matthias - I know, it is not the best solution, but the only possible one at current stage.

regards

Lech