Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

markp201
Contributor III

nprinting formula will not evaluate

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

Editor

Formula.PNG

Template

Template.PNG

Output

output.PNG

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

output2.PNG

1 Solution

Accepted Solutions
markp201
Contributor III

Re: nprinting formula will not evaluate

=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.

output2.PNG

8 Replies
roharoha
Valued Contributor III

Re: nprinting formula will not evaluate

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

markp201
Contributor III

Re: nprinting formula will not evaluate

Nice suggestion but same result - <vReportDate>

roharoha
Valued Contributor III

Re: nprinting formula will not evaluate

which version of NPrinting do you use?

markp201
Contributor III

Re: nprinting formula will not evaluate

16

roharoha
Valued Contributor III

Re: nprinting formula will not evaluate

how is your variable defined exactly?

markp201
Contributor III

Re: nprinting formula will not evaluate

=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.

output2.PNG

Not applicable

Re: nprinting formula will not evaluate

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
Contributor III

Re: nprinting formula will not evaluate

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

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

Community Browser