topic Re: Insert row and Formulas in Nprinting in Qlik NPrinting

Insert row and Formulas in Nprinting

Anonymous — Fri, 15 May 2015 14:58:56 GMT

I'm using NPrinting to create a report excel but I don't found a way to insert blank row or formulas that are not in the qlikview object.

For example (as shown in the attached table ) I would take a % of the turnover compared to the gross profit.

Thanks for collaboration.

Other Revenues	-80.064
TURNOVER	9.819.053

Direct Cost of Sales:
-Cost of sales of products	-5.061.767
-Production costs of products	-348.665

Gross Profit	4.408.622
% on Turnover	44,9%

Re: Insert row and Formulas in Nprinting

Frank_S — Fri, 03 Jul 2015 16:05:36 GMT

Although you cannot add a blank row if you use the top level chart object.

The report you appear to have created can be emulated using cell by cell reporting. You can place individual cells of a straight table chart exactly where you wish to place them in an excel report.

This way you can leave a blank row in the report as needed.

Selected QlikView Cell Values Used in Excel Reports – Customer Feedback for Vizubi