Nprinting breaks conditional formatting within a level

[nsm1234567]

Hi there,

I'm currently building a  Nprinting report (using November 2020) where I want the header of each section to use a colour based on the brand name.  This works fine until I try to do this within a level.  See my conditional formatting rule below.  When used in the level, the cell reference becomes #REF! .  In other words, the reference is being broken.  Any idea what's happening here or what a workaround might be?  I could build the headers in Qlik but that's more painful than just doing in excel.

[Frank_S · Accepted solution]

@nsm1234567 

I've created a simpler example which works...hope this help you.

[Lech_Miszkiewicz]

Hi this is quite simple. #REF! error appears in scenarios where you are referencing to the row which was removed due to the fact that <Level> wrapping tags are being removed. This is the same behaviour when in excel you have conditional formatting applied referencing another row and you delete that another row.

So the solution is to plan your conditional formatting the way it will not be impacted by potentially deleted rows. 

Cheers 

[nsm1234567]

Thank you.  Yeah, I see that it matters where the cell is that you're formatting.  If you reference a cell outside of the level it creates that #ref error i.e. the cell you're referencing must always be contained within the level

[Ruggero_Piccoli]

Hi,

When creating an Excel report, Qlik NPrinting add rows to be able to fill the report with all rows in the source table. That is why, if you reference the cells in the template, in the generated report you will have a #ref error. You can change this behaviour by using the Expand rows property https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Designer-properti... but in that case Qlik NPrinting will not add rows and inserting a table coul result in overwriting another. 

You can also add Excel native formulas by adding Excel native tables and add calculated columns to that native table. The calculated columns will be expanded correctly. You can also use native Excel formatting feature for tables.

Best Regards,

Ruggero