topic Re: Nprinting Excel pivot table design in Qlik NPrinting

Nprinting Excel pivot table design

lior_malcka — Tue, 26 Jan 2016 00:35:28 GMT

I am trying to create a color separation between different data in my Pivot table but nothing happens, when i try to add lines between data to create separation the Nprinting just print the lines with no logic on the output.

Does any one have a guide on how to design a pivot table or any data on Nprinting Excel?

Thanks,

Re: Nprinting Excel pivot table design

Wed, 27 Jan 2016 15:52:19 GMT

Hello Lior,

You have to make rules of conditionnal formating in your Excel template.

Best regards

Re: Nprinting Excel pivot table design

Daniel_Jenkins — Wed, 27 Jan 2016 20:44:01 GMT

Hi,

When it comes to Excel Pivot Table formatting, Conditional Formatting rules and ad-hoc formatting changes do not persist. They revert to the original once you save & re-open the file (template in QlikView NPrinting). In the past I have had to either use one of the in-built PivotTable styles or create my own.

HTH - Daniel.

Re: Nprinting Excel pivot table design

lior_malcka — Mon, 08 Feb 2016 12:35:39 GMT

Thank you all very much for your help