Nprint 16.5 - Format Excel Report

[wonkymeister]

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?

1. 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?
2. 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

[mkelemen]

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

[wonkymeister]

Thanks for the help Matus - most useful!