Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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