Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
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

Hi Gregory,

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

HTH - Daniel.

Not applicable

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

Forgot to include my attachment: