Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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/ImageDimensionManageme...
In Excel templates you can create native pivot tables:
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.
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.
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
---------------------------------------------
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.
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.
Hi,
You see the scroll bars that are fixed in the image. Try to enlarge the original image in Qlik Sense.
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.
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
Hi,
Give a check at the page https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Image-Dimension-Managemen....
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.
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)
Hi,
I did the attached report with April 2018.
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.