topic Re: nprinting formula will not evaluate in Qlik NPrinting

nprinting formula will not evaluate

markp201 — Thu, 22 Jun 2017 16:18:04 GMT

We have a variable in the document which evaluates in the editor but nprinting will not show in the output

Editor

Template

Output

What's odd is if the formula is placed on a new sheet, the evaluation works

Anonymous — Thu, 22 Jun 2017 16:20:43 GMT

add as variable instead of formula --> one row above

markp201 — Thu, 22 Jun 2017 16:24:01 GMT

Nice suggestion but same result - <vReportDate>

Anonymous — Thu, 22 Jun 2017 16:27:05 GMT

which version of NPrinting do you use?

markp201 — Thu, 22 Jun 2017 16:30:47 GMT

Anonymous — Thu, 22 Jun 2017 16:59:28 GMT

how is your variable defined exactly?

markp201 — Thu, 22 Jun 2017 17:08:06 GMT

=TEXT(RPT_DATE)

The report has a pivot table and what we found is if the variable is within two rows, it would not evaluate.

When another row was inserted, it worked. I think this qualifies as a bug.

Thu, 22 Jun 2017 17:16:20 GMT

It's probably an Excel issue having to do with dynamic ranges and pivot tables.

Is you need to eliminate rows between the formula and the pivot table, try using the delete row functionality on the rows you want to delete.

HTH

Aran Nathanson

markp201 — Thu, 22 Jun 2017 17:19:08 GMT

One of the first things we tried. Didn't work

We first built the pivot table manually in excel - didn't have this problem.