Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
lior_malcka
Partner - Contributor II
Partner - Contributor II

Nprinting Excel pivot table design

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,

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

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.

View solution in original post

3 Replies
Not applicable

Hello Lior,

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

Best regards

Daniel_Jenkins
Specialist III
Specialist III

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.

lior_malcka
Partner - Contributor II
Partner - Contributor II
Author

Thank you all very much for your help