topic Re: Excel Report -> Create PDF -> formula calculation does not work in Qlik NPrinting

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

schurter — Mon, 06 Jun 2016 15:04:51 GMT

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 — Mon, 06 Jun 2016 16:02:15 GMT

No so sure what you´re describing.

Would you mind sharing some data or screenshots?

Qrishna — Mon, 06 Jun 2016 16:11:15 GMT

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 — Mon, 06 Jun 2016 16:25:02 GMT

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 — Mon, 06 Jun 2016 19:44:57 GMT

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