topic Dynamic excel sheet with Predefined Formatting in NPrinting 17.2 in Qlik NPrinting

Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

Wed, 02 Nov 2016 13:03:06 GMT

Hi,

I have the following requirement. I have 9 Categories and 10-20 subcategories in each of them.

1. I need to create one sheet with tables for each category.

2. I need to create sheets for 4 fixed categories, with tables for their sub categories. And another sheet with remaining categories.

For these I have the above format.

I have tried using Levels, however this hampers formatting.

Overall I have near about 100 tables. I can make the report, if can create all the tables hard-coded using set analysis.

Even this does not keep the source template format. I have to format the tables manually. Moreover for any addition or change in category/Subcategory I would have to modify tables in App.

Is there a way to create these tables dynamically keeping formats?

Re: Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

Stephen_Jasionowski — Wed, 02 Nov 2016 15:08:39 GMT

If you uncheck "Keep source formatting" from the table properties in NPrinting before you drag-and-drop into the template, the template source formatting should be preserved.

Re: Dynamic excel sheet with Predefined Formatting in NPrinting 17.2

Thu, 03 Nov 2016 05:56:30 GMT

I have tried that. But could not keep the format.