Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adjusting Row Borders for Excel Report in nPrinting

I'm trying to create an excel report in nPrinting, where there are no cell borders except for above the total row.  I was thinking of either doing this in Qlikview or just adjusting the borders in nPrinting, wasn't sure what was easiest.

I've attached a very quick example as to how I need this to look, was wondering if anyone has an idea as to how to adjust just single rows borders, while having no borders for the rest of the data.

3 Replies
Daniel_Jenkins
Support
Support

Hi Gregory,

This is very easy to do in NPrinting using standard Excel formatting.

HTH - Daniel.

Not applicable
Author

Hey Daniel,

I appreciate the response, however it isn't that simple, as in nPrinting the format looks more like the attached.

What I need Is for this report to format where it finds the correct row based on the dimension value, and then applies formatting to the other columns.  I've been attempting this using Conditional Formatting and vLookup logic, but so far am not having much luck.

Not applicable
Author

Forgot to include my attachment: