topic Re: Nprinting 17.6 excel reference in Qlik NPrinting

Nprinting 17.6 excel reference

Anonymous — Wed, 21 Feb 2018 16:28:49 GMT

Hi,

I noticed a strange behaviour in Nprinting 17.6 (versus 17.3.) in excel references.

This is an example of reference to Cell C1 Inside level tags. To my experience this seems to work in 17.3.

However, when upgrading to 17.6. the reference changes when the a report is run over the template. The template has the reference to C1, but the outputted Report changes the reference to C2.

Has anyone else encountered this? this doesnt seem like normal behaviour.

Re: Nprinting 17.6 excel reference

curiousfellow — Thu, 09 May 2019 12:52:13 GMT

I know this is an old thread, but i am facing the same problem using levels.

We are still on 17.6 to.

Were you able to solve this ?

Re: Nprinting 17.6 excel reference

Frank_S — Thu, 09 May 2019 16:10:24 GMT

Hi @curiousfellow @Anonymous

The solution here 'may' be to remove 'expand range' attribute if I understand you requirement correctly.

The following is an NP 16 tutorial but it is the exact same design principle in the NP 17+ platform.

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Select-Top-Ranks-from-QlikView-and-Use-Them-With-Custom-Excel/ta-p/1485477

Re: Nprinting 17.6 excel reference

curiousfellow — Mon, 13 May 2019 09:04:12 GMT

I am sorry that I did not make my self clear.

You are refferring to a solution where every value of a dimension has to be recalculated. What I am looking for is a formula for the columnheader of a level.

for instance

header : ="year " & sheet2!E$2

row1 : firstrecordtable

row 2: secondrecordoftable

</level1>

header : ="year " & sheet2!E$2

row1 : firstrecordtable

row 2: secondrecordoftable

</level2>

Re: Nprinting 17.6 excel reference

Frank_S — Mon, 13 May 2019 23:16:31 GMT

I suggest that you move your column header above the NPrinting level 'open' tag.

In my test when I followed your method, I got this error:

=#REF!

When I move the header using the sheet/cell reference above the NP open level tag, it produced expected results.

It looks like you cannot use sheet/cell references inside the NP open and closing tags. I believe this to be working as designed.

Re: Nprinting 17.6 excel reference

curiousfellow — Tue, 14 May 2019 06:31:05 GMT

Thanks for your answer. When I move the column header above the 'open level' tag, the headers are printed only once, and that's just what I want to prevent

I understand that there is no solution at this moment.

@Frank_S: Sorry, cannot find an option to mark your answer as helpfull

Re: Nprinting 17.6 excel reference

Ruggero_Piccoli — Tue, 14 May 2019 10:03:35 GMT

Hi,

Could you share your template?

Re: Nprinting 17.6 excel reference

curiousfellow — Thu, 16 May 2019 09:41:31 GMT

Herewith a template that creates the same wrong reference.

I think it result in errors because the reference contains a link to the temp-file that is used when creating the report.

Re: Nprinting 17.6 excel reference

Ruggero_Piccoli — Mon, 27 May 2019 14:50:26 GMT

Hi,

Why are you inserting the headers inside the level? This means that the fixed strings of the headers will be repeated for every row.

To print the headers only one time at the top of the table in the produced reports you have to place them before the level opening tab as in the picture below:

Please test this and let us know if it resolves.

Best Regards,

Ruggero

Re: Nprinting 17.6 excel reference

curiousfellow — Tue, 28 May 2019 07:16:25 GMT

There are two reasons why I want the headers within a level.

1. I think it looks better when I repeat the headers, because there is some whitespace between each level.

2. Within a level I have more than one "table" with different information. Not each table has the same header.

Headers are dyamic

Re: Nprinting 17.6 excel reference

Ruggero_Piccoli — Tue, 28 May 2019 08:43:54 GMT

Hi,

Thanks for the clarification, now I understand what you want to have.

I tested the following solution in Qlik NPrinting April 2019.

In the second worksheet, where you insert the value1, value2 etc define the named cells https://support.office.com/en-us/article/create-or-change-a-cell-reference-c7b8b95d-c594-4488-947e-c835903cebaa. A different name for each cell that have the value you want to concatenate.

Than create the formulas in the worksheet with data. Note that those formulas will contain the references to the cell names.

Run a preview

Best Regards,

Ruggero

Re: Nprinting 17.6 excel reference

curiousfellow — Tue, 28 May 2019 11:47:00 GMT

Thank you Ruggero, this works indeed.

Would never have found this solution myself. (Cannot find the way to mark answer as correct)