Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

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
Support
Support

Re: Adjusting Row Borders for Excel Report in nPrinting

Hi Gregory,

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

HTH - Daniel.

Not applicable

Re: Adjusting Row Borders for Excel Report in nPrinting

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

Re: Adjusting Row Borders for Excel Report in nPrinting

Forgot to include my attachment: