Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Excel Report -> Create PDF -> formula calculation does not work

 

Good day everybody

 

I have an Excel report with a QlikView table. From this table, I create a Pivot next I added various formulas.

 

If I create a PDF from it, it has not charged me these formulas but! Have someone a solution for this problem?

Thank you in advance.

Marlies

 

4 Replies
Highlighted
Employee
Employee

No so sure what you´re describing.

Would you mind sharing some data or screenshots?

Specialist III
Specialist III

So you mean you are using a table from an excel sheet in qlikview and generating a pdf of that using NPrinting?

More clarifications needed here.

Highlighted
Creator
Creator

Hello,

I have a excel-NPrinting-Report named Report NFZ-Statistik template, see attached.

On the thirt sheet ESI in range B31 is a formula.

When I make a Task for this Report

- as xlsx --> Excel calculate, and all is OK

- as pdf you see in the picture NFZ-Statistik page 3.bmp that the formula is not calculated!!!

We would send the Report as PDF and not as Excel....

Thank's a lot for an answer.

Marlies

!

Highlighted
Specialist III
Specialist III

PDF is static report.

So the calculations should be perfomed at qlikview level and not at the PDF report level.

Please try calculation the expression at the Qlikview report level then publish the PDF of that report using NPrintin.

Hope that helps