topic Re: Adjusting Row Borders for Excel Report in nPrinting in Qlik NPrinting

Adjusting Row Borders for Excel Report in nPrinting

Wed, 30 Nov 2016 17:24:29 GMT

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.

Re: Adjusting Row Borders for Excel Report in nPrinting

Daniel_Jenkins — Thu, 01 Dec 2016 01:18:09 GMT

Hi Gregory,

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

HTH - Daniel.

Re: Adjusting Row Borders for Excel Report in nPrinting

Thu, 01 Dec 2016 15:19:53 GMT

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.

Re: Adjusting Row Borders for Excel Report in nPrinting

Thu, 01 Dec 2016 15:22:05 GMT

Forgot to include my attachment: