Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Nprinting 17.6 excel reference

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.

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

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-c.... A different name for each cell that have the value you want to concatenate.

Excel Concatenate Header 010.png

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

Excel Concatenate Header 020.png

Run a preview

Excel Concatenate Header 030.png

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

11 Replies
curiousfellow
Specialist
Specialist

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 ?

 

Frank_S
Support
Support

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

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
curiousfellow
Specialist
Specialist

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

<level1>

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

             row1 :         firstrecordtable

             row 2:        secondrecordoftable

</level1>

<level2>

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

             row1 :         firstrecordtable

             row 2:        secondrecordoftable

</level2>

Frank_S
Support
Support

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!

ref fails if header inside tags.PNG

 

 

 

 

 

 

 

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

working ref.PNG

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

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
curiousfellow
Specialist
Specialist

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

 

 

 

Ruggero_Piccoli
Support
Support

Hi,

Could you share your template?



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
curiousfellow
Specialist
Specialist

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.

Ruggero_Piccoli
Support
Support

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:

Level Headers.png

Please test this and let us know if it resolves.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
curiousfellow
Specialist
Specialist

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

multilpe tables within one level Nprinting.JPG