Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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 ?
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.
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>
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.
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
Hi,
Could you share your template?
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.
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
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