Hi,
About the use of Custom Rows in compination with Expand Range you can check this article Select Top Ranks from QlikView and Use Them With Custom Excel Formulas
Expand range can be used also alone. As default behavior, when creating a table in an Excel report Qlik NPrinting adds a number of rows under the table. So if you place the tags for two tables one under the other with Expand range active Qlik NPrinting will add the rows that are necessary to display the first table and then it starts to expand the second. In this way you are sure to have all rows but Excel references are not kept.
If you unflag Expand range, Qlik NPrinting will overwrite objects that in case are under the first object.
I would to suggest to try by yourself.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
