Discussion Board for collaboration on Qlik NPrinting.
I created an Excel report containing a page for every dimension.
The last sheet contains the data retrieved form a qlik app
In the excel template I use a formula like :
When previewing the results, or when I run this report in a task, the formula's in the report are changed to :
When I use the same formula without the "page-level-indicator" formulas are calculated correctly
How to solve this ?
We are using Nprinting 17.6.0000.0
Thanks @jaimeaguilar ! I'd been using an Excel 'data table', which wasn't working, and I hadn't thought of changing that to a plain old named range.
The named range worked perfectly for me.
@curiousfellow if you're able to get the same result, it'd be great to mark Jaime's answer as correct.
View solution in original post
you need to use named ranges, so they don't get replaced by temp file references. I include a link where you can check how to use named ranges in Excel: