Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

curiousfellow
New Contributor III

Nprinting adds link to temp file in excel formula

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 :

=sumif(data!DSmiley Very Happy;C9;E:E)

When previewing the results, or when I run this report in a task, the formula's in the report are changed to :

=SUMIF('C:\Users\myname\AppData\Local\Temp\f1cea6a6c8044804b3fbc2233270d175\[20180314030001.xlsx]Data'!B:B;C8;'C:\Users\myname\AppData\Local\Temp\f1cea6a6c8044804b3fbc2233270d175\[20180314030001.xlsx]Data'!DSmiley Very Happy)

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

Community Browser