Complex Pivot table in n printing? - Qlik Community

arvind1494 · ‎2018-09-06

Hi All,

My client wants complex pivot table in excel on daily basis.

Please tell me is it possible to create such a complex pivots in n printing.

jonathandienst · ‎2018-09-06

That really depends on what you mean by complex. Can you build and render the pivot in Qlik? Then, in general, you will be able to render in nPrinting.

If the pivot is expensive to calculate, make sure the nPrinting engine is on a server with sufficient RAM.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Ruggero_Piccoli · ‎2018-09-06

Hi,

Qlik NPrinting supports Excel pivot tables. Of course you must respect the Excel limitations.

Refer to https://help.qlik.com/en-US/nprinting/June2018/Content/ExcelReports/Pivot-table-Excel.htm

Performances depends on your hardware resources and the number of Qlik NPrinting Engines. Refer to https://help.qlik.com/en-US/nprinting/June2018/Content/DeployingQVNprinting/Performance.htm

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.

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Lech_Miszkiewicz · ‎2018-09-06

Why would you worry about RAM on NPrinitng engine? Using QVP connection would solve this issue - right?

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.