Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
|
|
|
Direct Cost of Sales: |
|
-Cost of sales of products | -5.061.767 |
-Production costs of products | -348.665 |
|
|
Gross Profit |
|
% on Turnover | 44,9% |
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