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

[schurter]

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

[Clever_Anjos]

No so sure what you´re describing.

Would you mind sharing some data or screenshots?

[Qrishna]

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.

[schurter]

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

!

[Qrishna]

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