topic Nprint 16.5 - Format Excel Report in Qlik NPrinting

Nprint 16.5 - Format Excel Report

wonkymeister — Fri, 02 Dec 2016 11:10:31 GMT

Hi,

I've created an Excel report in NPrint, of a dozen columns of numeric values, with the dimension in the first column (so standard table) - there's 2 things i'd like to format if its possible?

The grand total is on the first row, rather than the last - is it possible in NPrint to force the total to the last row?
In the object in Qlik I use dimension limits to subtotal the values in my report - is it possible to make the sub total row a different colour?

thanks in advance,

Phil.

Qlik 11.2 SR12

NPrint 16.5

Re: Nprint 16.5 - Format Excel Report

mkelemen — Mon, 05 Dec 2016 12:09:23 GMT

Hi Phil,

1. I do not know if this is possible directly in NPrinting/PPT but you can change total to last row in Chart properties / Presentation.

2. You need to use background color of expressions and dimensions and use the Dimensionality() to find out at which level you are. Note - use Dimension limits Total to get background color in dimensions, the expression total does not honor it.

So expression like this will give you red for Total, green for subtotals and blue for normal rows.

Pick(Dimensionality() + 1, red(), green(), blue())

BR,

Matus

Re: Nprint 16.5 - Format Excel Report

wonkymeister — Wed, 07 Dec 2016 11:16:11 GMT

Thanks for the help Matus - most useful!